1.
SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON
GO /*--你的SQL脚本开始*/
SELECT [TestCase] FROM [TestCaseSelect]
GO /*--你的SQL脚本结束*/
SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
2、declare@ctdatetime
set@ct=getdate()
---
--sql 语句
---
selectdatediff(ms, @ct ,getdate()) as'查询时间(毫秒)'