create table tablename
(
id int
)
go
declare @i int
set @i=1
while @i<100
begin
insert into tablename values(@i)
set @i=@i+1
waitfor delay '00:00:05'
end
waitfor delay 用于SQL的延迟一段时间再继续执行
create table tablename
(
id int
)
go
declare @i int
set @i=1
while @i<100
begin
insert into tablename values(@i)
set @i=@i+1
waitfor delay '00:00:05'
end
waitfor delay 用于SQL的延迟一段时间再继续执行