php快速循环1000条数据,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 [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,

@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