sql字符串如何连接

sql字符串怎么连接？
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

怎么不行呀，如何处理呢？

[解决办法]

SQL code

CREATE proc find_count_num(  @sql_text nvarchar(1000)='',@result int output)asbeginset @sql_text=N'select @cnt=count(*) from tsyslog '+@sql_textexec sp_executesql @sql_text,N'@cnt int output',@result outputendGO