- 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
- --该片段来自于http://www.codesnippet.cn/detail/160420149305.html
来源: http://www.codesnippet.cn/detail/160420149305.html