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