批量执行sql语句的方法

复制代码 代码如下:

declare @mycounter int

set @mycounter = 0 /*设置变量*/

while (@mycounter < 2) /*设置循环次数*/

begin

waitfor delay ‘000:00:1’ /*延迟时间1秒*/

insert into comments (username)

values(‘ahuinan’)

set @mycounter = @mycounter + 1

end