SQL执行时间计算两种方法

1. 自定义的

declare @watch datetime;

set @watch=getdate();

select * from table;

select datediff(ms,watch,getdate()) as elapsedTime;

 

2. 系统提供的

set statistics time on

select * from table

set statistics time off

结果输出在消息窗口里,如:

SQL Server Execution Times:
   CPU time = 0 ms,  elapsed time = 17 ms.