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.