查看SQL语句的的执行时间

打开SQL Server的查询分析器。在下面语句两个go中间加入要执行的sql语句。

set statistics profile on
set statistics io on
set statistics time on
go
<这里写上你的语句...>
go
set statistics profile off
set statistics io off
set statistics time off

例如:

SET STATISTICS io ON
SET STATISTICS time ON 
go
SELECT *  FROM TBL_MeetingRoomOrder 
go
SET STATISTICS profile OFF
SET STATISTICS io OFF
SET STATISTICS time OFF

结果: