--数字不能做表名
DECLARE @S VARCHAR(8);
set @S = 'a';
SET @S =@S+convert(varchar(4),datepart(yyyy,getdate()))+convert(varchar(4),datepart(mm,getdate()))+convert(varchar(4),datepart(dd,getdate()));
EXEC ('SELECT * INTO ['+@S+'] FROM dbo.pe')
或者
DECLARE @S VARCHAR(8);
set @S = 'a';
SET @S =@S+convert(varchar(4),datepart(yyyy,getdate()))+convert(varchar(4),datepart(mm,getdate()))+convert(varchar(4),datepart(dd,getdate()));
EXEC ('SELECT * INTO '+@S+' FROM dbo.pe')
DECLARE @S VARCHAR(8);
set @S = 'a';
SET @S =@S+convert(varchar(4),datepart(yyyy,getdate()))+convert(varchar(4),datepart(mm,getdate()))+convert(varchar(4),datepart(dd,getdate()));
EXEC ('SELECT * INTO ['+@S+'] FROM dbo.pe')
或者
DECLARE @S VARCHAR(8);
set @S = 'a';
SET @S =@S+convert(varchar(4),datepart(yyyy,getdate()))+convert(varchar(4),datepart(mm,getdate()))+convert(varchar(4),datepart(dd,getdate()));
EXEC ('SELECT * INTO '+@S+' FROM dbo.pe')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货