34,576
社区成员
发帖
与我相关
我的任务
分享
use A;
go
declare @tname varchar(20)
set @tname='A'+convert(varchar(8),getdate(),112)
exec ('select * into ['+@tname+'] from db.表名B')
EXEC('select * into A'+COVNERT(VARCHAR(20),GETDATE(),120)+' from db.表名B')
declare @sql varchar(1000)
set @sql='select * into [A'+convert(varchar(10),getdate(),120)+'] from db.表名B
'
exec(@sql)
select * into b库.dbo.tb from a库.dbo.ta