declare @i int
set @i=1 while (@i<100) begin set rowcount 500 update table set flag=1 where flag!=1 waitfor delay '00:00:1' set @i=@i+1 end |
declare @i int
set @i=1 while (@i<100) begin set rowcount 500 update table set flag=1 where flag!=1 waitfor delay '00:00:1' set @i=@i+1 end |