34,594
社区成员
发帖
与我相关
我的任务
分享
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')