ホームページ >データベース >mysql チュートリアル >SQL 循环插入1000条数据
自己测试的一个应用 无 DECLARE @i intDECLARE @identifier uniqueidentifierDECLARE @Uuid uniqueidentifierDECLARE @ProductName nvarchar(MAX)DECLARE @ProtectFlag bitDECLARE @name nvarchar(max)DECLARE @ManagedStatus intDECLARE @SummaryStatus intD
自己测试的一个应用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