Sql Server 2005 存储过程 求救

[m20058259]

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select count(distinct b.id) as num into @tempcount from ' +@filter ' '
set @b=(select num from @tempcount)
exec(@s_sql)
go


消息 102，级别 15，状态 1，过程 test，第 6 行
' ' 附近有语法错误。
消息 1087，级别 15，状态 2，过程 test，第 7 行
必须声明表变量 "@tempcount"。

[-晴天]

错误百出.

[唐诗三百首]

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select count(distinct b.id) as num into @tempcount from ' + @filter +' '
set @b=@s_sql+ ' select num from @tempcount) '
exec(@s_sql)
go

[AcHerat]

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select @count=count(distinct b.id) as num from ' +@filter+ ''
exec sp_executesql @s_sql,N'@count int output',@b output
go

[唐诗三百首]

虽然我太清楚楼主这个SP要做什么,只能保证语法正确了.

[-晴天]

try:

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select @tempcount=count(distinct id) from ' +@filter 

exec SP_EXECUTESQL @s_sql,N'@b int output ',@b output 

go

[AcHerat]

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select @count=count(distinct b.id) from ' +@filter+ ''
exec sp_executesql @s_sql,N'@count int output',@b output
go

[m20058259]

谢谢大家帮忙。

[--小F--]

create proc test
@filter varchar(500),
@b int output
as
declare @s_sql nvarchar(max)
set @s_sql= 'select @count=count(distinct b.id) from ' +@filter+ ''
exec sp_executesql @s_sql,N'@count int output',@b output
go