--SQL语句前加:
declare @d datetime,@temp int
set @d=getdate()
--SQL语句
set @temp=1
while @temp<=1000
begin
print @temp
set @temp=@temp+1
end
--在SQL语句后加:
select @d AS '开始时间', getdate() AS '结束时间' , datediff(ms,@d,getdate()) AS '执行时间'
declare @d datetime,@temp int
set @d=getdate()
--SQL语句
set @temp=1
while @temp<=1000
begin
print @temp
set @temp=@temp+1
end
--在SQL语句后加:
select @d AS '开始时间', getdate() AS '结束时间' , datediff(ms,@d,getdate()) AS '执行时间'