sql 语句中的表名怎么用变量

[yangcdan]

declare @mxtbname varchar(20)
set @mxtbname='fhg'


select * from @mxtbname

这样的语句该怎么实现

[nianran520]

declare @mxtbname varchar(20) 

set @mxtbname='fhg' 

exec('select * from '+ @mxtbname)

[让你望见影子的墙]

exec('select * from '+@mxtbname )

[中国风]

只可用動態
declare @mxtbname varchar(20),@s nvarchar(1000)
set @mxtbname='fhg'


set @s='select * from ['+@mxtbname+']'
exec(@s)

[andysun88]

UP，晚了

[百年树人]

当表名和字段名是变量时，要用动态SQL，参考1楼

[yangcdan]

1的不可以
提示 必须声明变量 '@fhg'。

[yangcdan]

谢啦，现在可以啦
谢谢各位。。

[无锡阔微信息科技]

if object_id('tb') is not null
drop table tb
go
create table tb(id int)
insert into tb
select 1 union all
select 4 union all
select 3 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1 union all
select 1

declare @str nvarchar(500)
declare @table nvarchar(10)
set @table='tb'
set @str='select * from '+@table
exec (@str)