declare @tn varchar(100),@sql varchar(1000)
select top 1 @tn=name from sysobjects where xtype='u' and left(name,8)='aabbccdd' order by name desc
set @sql='select * from '+@tn
exec(@sql)
--如果每天生成一个表
declare @tablename varchar(100)
select @tablename=[name] from sysobjects where xtype='U' and convert(varchar(10),crdate,120)=convert(varchar(10),getdate(),120)
exec('select * from '+@tablename)
declare @tn varchar(100),@sql varchar(1000)
select top 1 @tn=name from sysobjects where xtype='u' and left(name,8)=aabbccdd order by name desc
set @sql='select * from '+@tn
exec(@sql)
declare @name varchar(100)
declare cur_1 cursor for
select [name] from sysobjects where xtype='U'
open cur_1
fetch next from cur_1 into @name
while @@FETCH_STATUS
begin
exec('select * from '+@name)
fetch next from cur_1 into @name
end