SQL循环插入1000条数据

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 =@i +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,
 @ManagedStatus,
 @ThreadId,
 @LastUpdateDate)
 
insert into [dbo].[TBL_ManagerRelation]
 ([ManagerId]
 ,[TargetId]
 ,[ManagementKey]
 ,[ThreadId]
 ,[LastUpdateDate])
 values
 (@managerId,
 @identifier,
 @name,
 @ThreadId,
 @LastUpdateDate
 )
insert into [dbo].[TBL_ManagerRelation]
 ([ManagerId]
 ,[TargetId]
 ,[ManagementKey]
 ,[ThreadId]
 ,[LastUpdateDate])
 values
 (@managerId1,
 @identifier,
 @name,
 @ThreadId,
 @LastUpdateDate
 )
 
insert into [dbo].[TBL_ManagerRelation]
 ([ManagerId]
 ,[TargetId]
 ,[ManagementKey]
 ,[ThreadId]
 ,[LastUpdateDate])
 values
 (@managerId2,
 @identifier,
 @name,
 @ThreadId,
 @LastUpdateDate
 )
 
End