SQL 循环插入1000条数据

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

DECLARE @i int
DECLARE @identifier uniqueidentifier
DECLARE @Uuid uniqueidentifier
DECLARE @ProductName nvarchar(MAX)
DECLARE @ProtectFlag bit
DECLARE @name nvarchar(max)
DECLARE @ManagedStatus int
DECLARE @SummaryStatus int
DECLARE @Location nvarchar(MAX)
DECLARE @SubstanceFlag bit
DECLARE @type int
DECLARE @Path nvarchar(max)
DECLARE @ManagedSubStatus int
DECLARE @LastUpdateDate datetime
DECLARE @ThreadId nvarchar(MAX)
DECLARE @managerId uniqueidentifier
DECLARE @managerId1 uniqueidentifier
DECLARE @managerId2 uniqueidentifier

Set @i = 1

WHILE @i < 3000
BEGIN
set @managerId = 'A9B47402-ADA9-E311-A64D-782BCB92E944'
Set @i [email?protected] +1
set @identifier = NewID()
set @Uuid = NewID()
Set @ProductName = 'VMWare Virtual Machine 10' 
set @ProtectFlag = 0
set @name = RIGHT('vm-test' + CAST(@i AS nvarchar(MAX)),20)
set @ManagedStatus = 2
set @SummaryStatus = 32
Set @Location = 'Storage_1.82T'
set @SubstanceFlag = 1
set @type = 1114112
set @path = RIGHT('[Storage_1.82T] vm1_ByVMClone/vm-test.vmx' + cast(@i AS nvarchar(MAX)),50)
set @ManagedSubStatus = 1
set @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

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：济南站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!