set @sqls='select @t=count(*) from news'+ @findtext
exec sp_executesql @sqls,N'@t int output',@rowcount output
select @rowcount
exec sp_executesql @sqls,N'@t int output',@rowcount output
select @rowcount
调试欢乐多
declare @sql Nvarchar(2000)
set @sql=N'select @rowcount=count(*) from news'+ @findtextEXECUTE sp_executesql @sql, N'@rowcount int output',@rowcount output
@findtext nvarchar(100),
@rowcount int output)
as
begin
~~~/* '我想在这里给输出变量@rowcount赋值,但要用到输入参数 @findtext(这是个where条件字符串) exec('select @rowcount=count(*) from news'+ @findtext)
*/
declare @sqls nvarchar(4000)
set @sqls='select @a=count(*) from news '+@findtext
exec sp_executesql @sqls,N'@a int output',@rowcount output
~~~
declare @sql nvarchar(4000)
set @sql='select @a=count(*) from news '+@findtext
exec sp_executesql @sqls,N'@a int output',@rowcount output