declare @alu int
declare @tablename varchar(20)
set @tablename = 'byb '
set @alu = (select state from @tablename)
select @alu
本问题和一般变量取表名的问题不同的是，它多了一步取返回值的问题。
set @alu = (select state from @tablename)[email protected]xec( 'select state from ' + @tablename)[email protected]??。向高手们赐教！
------解决方案--------------------
declare @alu int
declare @tablename varchar(20)
set @tablename = 'byb '
declare @sql nvarchar(200)
set @sql=N 'select @alu=state from '[email protected]
exec sp_executesql @sql,N '@alu int output ',@alu output
select @alu