存储过程中使用变量问题

[zdw2521]

--实现直接打开@Adder 变量中的数据库
DECLARE @Adder VarChar(200)
Set @Adder ='AAAA'
use @Adder
Select * From
--或直接查询@Adder数据库中的Testge

DECLARE @Adder VarChar(200)
Set @Adder ='AAAA'
Select * From @Adder..Test

请大家帮忙看一下怎么样来正确使用@Adder变量

[bancxc]

exec('Select * From '+@Adder+'..Test')

[SQL77]

DECLARE @Adder nVarChar(200)
Set @Adder ='AAAA'   
EXEC('Select * From ['+@Adder+']..[Test]')

[bancxc]

exec('Select * From '+@Adder+'..Test')

[GoAwayZ]

DECLARE @Adder VarChar(200)
Set @Adder ='AAAA'   
exec('Select * From '+@Adder+'..Test')

[chuanzhang5687]

DECLARE @Adder nVarChar(200)
Set @Adder ='AAAA'   
EXEC('Select * From ['+@Adder+']..[Test]')

[AcHerat]

declare @str varchar(4000)
set @str = 'Select * From '+@Adder+'..Test'
exec(@str)

[yubofighting]

[Quote=引用 6 楼 acherat 的回复:]
SQL code

declare @str varchar(4000)
set @str = 'Select * From '+@Adder+'..Test'
exec(@str)
[/Quote]

还是这个规范一点

[zdw2521]

谢谢大家，搞定了。