返回任何SQL执行时间(到毫秒)

时间:2020-02-04 11:44:02   收藏:0   阅读:103
 CREATE proc TestTimeAnySentence 
@sql_where varchar(8000) 
as 
declare @ct datetime 
set @ct = getdate() 
declare @newsql_where varchar(8000) 
set @newsql_where=@sql_where 
exec(@newsql_where) 
select datediff(ms, @ct ,getdate()) as 查询时间(毫秒) 
go 
TestTimeAnySentence select * from 水费表 where 费用ID<200000

 

原文:https://www.cnblogs.com/cdoneiX/p/12258565.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!