如何获得执行某一存储过程或者SQL语句 10000次时的时间统计

Question

如题所述

Answer 1

drop table loopData;
create table loopData(id int identity(1,1), dt datetime)
delete from loopData

declare @dt datetime, @count int
set @dt=getdate()
set @count = 0
while @count <= 10000
begin
insert into loopData(dt) select getdate()
set @count = @count + 1
end

print datediff(ss, @dt, getdate())

Answer 2

自已编写测试代码。