项目中有很多表,表名都是“id+2019”,我的思路是先查询表名select name from sys.tables where name like 'id%';
再查询tablename=name这张表数据,具体实现是:
declare @tbname varchar(100)
select @tbname=name from sys.tables where name like 'id%';
exec('select * from '+@tbname')
-----------------------------------------------------------------
declare @tbname varchar(20)
select @tbname=name from sys.tables where name like '历史记录_%71_2019'
Exec('select top 100 * from ' +@tbname)