sqlserver執行時間和自行效率

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



declare @dtm datetime
SQL語句

print '新增person臨時表資料:'+convert(varchar(10),DATEDIFF(ms,@dtm,getdate())) 
select @dtm=GETDATE()

SQL語句

print '新增person臨時表資料:'+convert(varchar(10),DATEDIFF(ms,@dtm,getdate())) 
select @dtm=GETDATE()



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