Insert 1000 data records in SQL Loop

No DECLARE @ iintDECLARE @ tags @ ProductNamenvarchar (MAX) DECLARE @ ProtectFlagbitDECLARE @ namenvarchar (max) DECLARE @ ManagedStatusintDECLARE @ SummaryStatusintD

No DECLARE @ I intDECLARE @ identifier labels @ Uuid labels @ ProductName nvarchar (MAX) DECLARE @ ProtectFlag bitDECLARE @ name nvarchar (max) DECLARE @ ManagedStatus intDECLARE @ SummaryStatus intD

An application tested by yourself <无>

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 =@i +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, @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