执行下面即可看到效果，执行时间，CPU时间，占用时间

SET STATISTICS PROFILE ON
SET STATISTICS IO ON
SET STATISTICS TIME ON

declare @d datetime
set @d=getdate()

--要执行的语句（如select 1+2）

select 1+2

select [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())

SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF