请教一个SQL的正确用法

[j99616]

set @string='select @signdate=a from #bb where a like'+ @name
exec(@string)

提示我“@signdate”没有声明，但是我声明过了
请指教正确的用法

[CrazyFor]

参考:

declare @tcnt int
declare @paras varchar(100)
DECLARE @SQLString NVARCHAR(500)
set @paras ='1,3,5'
set @sqlstring=N'select @cnt=count(*) from sysobjects where id in ('+@paras+')'

set @tcnt=0
execute sp_executesql
@sqlstring,
N'@cnt int output',
@cnt=@tcnt output
select @tcnt


select * from sysobjects


参考:
Create Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end

[txlicenhe]

http://expert.csdn.net/Expert/topic/2364/2364046.xml?temp=.829693
[交流]动态SQL语句

declare @signdate varchar(10),@string nvarchar(4000),@name varchar(10)

set @string='select @signdate=a from #bb where a like'+ @name
exec sp_executesql @string,N'@signdate varchar(10) output',@signdate output
select @signdate

[mywhsw]

declare @string varchar(1000)
set @string='declare @signdate varchar(1000)'+char(13)+
'select @signdate=a from #bb where a like'+ @name
exec(@string)

[pengdali]

declare @string Nvarchar(4000)


set @string=N'select @signdate=a from #bb where a like '+ @name

exec sp_executesql @string,N'@signdate int output',@signdate output

[gmlxf]

http://www.algonet.se/~sommar/dynamic_sql.html

[j99616]

谢谢大家