sqlserver中循环生成记录

declare @i int
set @i=1
while(@i<=10)
begin
INSERT INTO [BMData].[dbo].[QueryBlackListLogs]
           ([ID]
           ,[LoginUserID]
           ,[QueryTime])
     VALUES
           (newid()
           ,'FEE1D95B-5FC3-4F9C-8D29-C6058978A7D6'
           ,GETDATE()
        )
set @i=@i+1
end
原文地址:https://www.cnblogs.com/25miao/p/6743727.html