SQL 循环插入1000条数据

概述SQL 循环插入1000条数据

下面是内存溢出 jb51.cc 通过网络收集整理的代码片段。

内存溢出小编现在分享给大家，也给大家做个参考。

DECLARE @i intDECLARE @IDentifIEr uniqueIDentifIErDECLARE @UuID uniqueIDentifIErDECLARE @Productname nvarchar(MAX)DECLARE @ProtectFlag bitDECLARE @name nvarchar(max)DECLARE @ManagedStatus intDECLARE @SummaryStatus intDECLARE @Location nvarchar(MAX)DECLARE @SubstanceFlag bitDECLARE @type intDECLARE @Path nvarchar(max)DECLARE @ManagedSubStatus intDECLARE @LastUpdateDate datetimeDECLARE @ThreadID nvarchar(MAX)DECLARE @managerID uniqueIDentifIErDECLARE @managerID1 uniqueIDentifIErDECLARE @managerID2 uniqueIDentifIErSet @i = 1WHILE @i < 3000BEGINset @managerID = 'A9B47402-ADA9-E311-A64D-782BCB92E944'Set @i [email protected] +1set @IDentifIEr = NewID()set @UuID = NewID()Set @Productname = 'VMWare Virtual Machine 10' set @ProtectFlag = 0set @name = RIGHT('vm-test' + CAST(@i AS nvarchar(MAX)),20)set @ManagedStatus = 2set @SummaryStatus = 32Set @Location = 'Storage_1.82T'set @SubstanceFlag = 1set @type = 1114112set @path = RIGHT('[Storage_1.82T] vm1_ByVMClone/vm-test.vmx' + cast(@i AS nvarchar(MAX)),50)set @ManagedSubStatus = 1set @ThreadID ='4'set @LastUpdateDate = cast('2014-03-12 14:10:56.660' as datetime)set @managerID1 = '4DEB2D12-ADA9-E311-A64D-782BCB92E944'set @managerID2 = 'E1F45D47-B7BF-E311-A9C7-782BCB92E944'insert into [dbo].[TBL_Machine]			([IDentifIEr],[UuID],[Productname],[ProtectFlag],[name],[ManagedStatus],[SummaryStatus],[Location],[SubstanceFlag],[OperatingSystemStatus],[Type],[Path],[ManagedSubStatus],[ThreadID],[LastUpdateDate])			 values			 (@IDentifIEr,@UuID,@Productname,@ProtectFlag,@name,@ManagedStatus,@SummaryStatus,@Location,@SubstanceFlag,1,@type,@Path,@ThreadID,@LastUpdateDate)insert into  [dbo].[TBL_ManagerRelation]           ([ManagerID],[TargetID],[ManagementKey],[LastUpdateDate])		   values		   (@managerID,@IDentifIEr,@LastUpdateDate		   )insert into  [dbo].[TBL_ManagerRelation]           ([ManagerID],[LastUpdateDate])		   values		   (@managerID1,@LastUpdateDate		   )insert into  [dbo].[TBL_ManagerRelation]           ([ManagerID],[LastUpdateDate])		   values		   (@managerID2,@LastUpdateDate		   )End

以上是内存溢出(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

总结

以上是内存溢出为你收集整理的SQL 循环插入1000条数据全部内容，希望文章能够帮你解决SQL 循环插入1000条数据所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。