动态表名如何写

[aykang]

declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'

select @parent=Path from [xiaoqu_manage] where ID=2
from 后面如何写@table

[sdhdy]

declare @parent varchar(200),@table varchar(2000) 
set @table='xiaoqu_manage' 
--------------------------------------------------------------
declare @sqlstring nvarchar(1000)
set @sqlstring=N'select @parent=Path from '+@table+' where ID=2 '
exec sp_executesql @sqlstring,N'@parent varchar(200) output',@parent output
select @parent
--------------------------------------------------------------

[sdhdy]

declare @parent varchar(200),@table varchar(2000) 
set @table='xiaoqu_manage' 
--------------------------------------------------------------
declare @sqlstring nvarchar(1000)
set @sqlstring=N'select @parent=Path from '+@table+' where ID=2 '
exec sp_executesql @sqlstring,N'@parent varchar(200) output',@parent output
select @parent
--------------------------------------------------------------

[htl258_Tony]

[Quote=引用 2 楼 htl258 的回复:]
SQL codedeclare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'

exec('select @parent=Path from '+@table+' where ID=2')
[/Quote]

declare @parent varchar(200),@table varchar(2000),@s nvarchar(4000)
set @table='xiaoqu_manage' 
set @s=N'select @a=Path from ' + @table + ' where id = 2'
exec sp_executesql @s,N'@a varchar(200) output',@parent output 
select @parent

SOYYR,没看到里面的变量,更正.

[playwarcraft]

exec ('select * from ' +@table)

[htl258_Tony]

declare @parent varchar(200),@table varchar(2000) 
set @table='xiaoqu_manage' 

exec('select @parent=Path from '+@table+' where ID=2') 

[-狙击手-]

exec('select * from '+@table)

[-狙击手-]

declare @parent varchar(200),@table varchar(2000) ,@sql nvarchar(4000)
set @table='xiaoqu_manage' 

set @sql = N'select @parent=Path from '+@table+' where ID=2'

exec sp_excutesql @sql,N'@parent varchar(2000) output',@parent out

select @parent

[-狙击手-]

sp_excutesql - > sp_executesql

sorry

[dawugui]

[Quote=引用楼主 aykang 的帖子:]
declare @parent varchar(200),@table varchar(2000)
set @table='xiaoqu_manage'

select @parent=Path from [xiaoqu_manage] where ID=2
from 后面如何写@table
[/Quote]

declare @parent varchar(200),@table varchar(2000) 
set @table='xiaoqu_manage' 

set @sqls='select @a=Path from ' + @table + ' where id = 2'
exec sp_executesql @sqls,N'@a varchar(200) output',@parent output 


select @parent