一张aa表有2个字段,一个是ID 一个是tablename ,tablename下面的记录是另一张表的表名.现在通过id来检索tablename下面字段表名,然后通过这个表名去检索那表的记录 该怎么写,
select * from (select tablename from industry_tablename where induaid=01)t跟select tablename from industry_tablename where induaid=01显示出来的效果一样,怎么改,怎么写.
select * from (select tablename from industry_tablename where induaid=01)t跟select tablename from industry_tablename where induaid=01显示出来的效果一样,怎么改,怎么写.
select @tablename=tablename from industry_tablename where induaid=01
exec ('select * from '+@tablename)
和普通的sql语句一样用就可以了
declare @sqlstring nvarchar(100)
declare @tableName nvarchar(20)
set @tableName=(select tablename from industry_tablename where induaid=01)
set @sqlstring='select * from '+ @tablename +'
exec sp_executesql @sqlstring