34,838
社区成员




declare @tablename varchar(20)
set @tablename='#20120101'
exec ('create table '+@tablename +'(id int) insert into '+
@tablename+' select 1 select * from '+@tablename)
/*
id
-----------
1
*/
exec(' select * into #'+convert(varchar(10),getdate(),120)+'AC from tb
select * from #'+convert(varchar(10),getdate(),120)+'AC')