SQL循环插入1000条数据

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了SQL循环插入1000条数据，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2243字，纯文字阅读大概需要4分钟。

内容图文

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

内容总结

以上是互联网集市为您收集整理的SQL循环插入1000条数据全部内容，希望文章能够帮你解决SQL循环插入1000条数据所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端