declare @sql varchar(3000)
set @sql='select * from t_kqcount'--SQL执行语句
declare @sql1 varchar(3000)
set @sql1='select 记录数=count(*) from ('+@sql+')a'
exec(@sql1)
只针对查询语句
declare @sql varchar(3000)
set @sql='select * from t_kqcount'--SQL执行语句
declare @sql1 varchar(3000)
set @sql1='select 记录数=count(*) from ('+@sql+')a'
exec(@sql1)