一个菜鸟问题
问一个菜鸟问题，变量替换数据库名称行不通，可否解决？

declare @name char(20)
set @name='master'
select * from @name.sys.objects

/* Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'. */

[解决办法]

SQL code

declare @name char(20)set @name='master'exec('select * from '+@name+'.sys.objects')
[解决办法]
SQL code
declare @name char(20)set @name='master'exec('select * from '+@name+'.sys.objects')
[解决办法]
SQL code
declare @name char(20)set @name='master'exec('select * from '+@name+'.sys.objects')--都是山寨我的，哼哼哼[img=http://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/onion/5.gif][/img]
[解决办法]
SQL code
declare @name char(20)set @name='master'exec('select '''+@name+''',max(create_date) from '+@name+'.sys.objects')                     -------------------- -----------------------master               2012-03-31 11:34:07.700(1 row(s) affected)