SQL语句执行效率及性能测试

SET STATISTICS PROFILE ON SET STATISTICS IO ON SET STATISTICS TIME ON GO /*--你的SQL脚本开始*/ SELECT * FROM tablename GO /*--你的SQL脚本结束*/ SET STATISTICS PROFILE OFF SET STATISTICS IO OFF SET STATISTICS TIME OFF

declare @d datetime set @d=getdate() /*你的SQL脚本开始*/ SELECT [TestCase] FROM [TestCaseSelect] /*你的SQL脚本结束*/ select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())