返回任何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)