SQL语句的写法.

[asuyr]

各位大虾:
如果有一张表为dbname
查询全部用.
select * from dbname
但,我想用变量来表示表名.
如
select * from @table
但这样子在分析器中是错误的.
请问怎么写.

[txlicenhe]

exec('select * from '+@table)

[zjcxc]

--用exec执行就行了.
exec('select * from '+@table)

[gmlxf]

declare @TName varchar(127)
set @TName='a'
exec('select * from ' + @TName)

[asuyr]

谢谢各位啦.!