5,388
社区成员
发帖
与我相关
我的任务
分享
CREATE proc find_count_num
(
@sql_text nvarchar(1000)='',
@result int output
)
as
begin
set @sql_text=N'select @cnt=count(*) from tsyslog '+@sql_text
exec sp_executesql @sql_text,N'@cnt int output',@result output
end
GO
CREATE proc find_count_num
(
@sql_texte varchar(1000),
@result int out
)
with encryption
as
begin
set @result='(select count(*) from sp_xx where '+@sql_texte+' )'
end
GO
set @result='select count(*) from sp_xx where ' +@sql_texte