复制代码 代码如下:

USE NBDXMIS

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'