--实现直接打开@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变量
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变量
Set @Adder ='AAAA'
EXEC('Select * From ['+@Adder+']..[Test]')
Set @Adder ='AAAA'
exec('Select * From '+@Adder+'..Test')
Set @Adder ='AAAA'
EXEC('Select * From ['+@Adder+']..[Test]')
declare @str varchar(4000)
set @str = 'Select * From '+@Adder+'..Test'
exec(@str)