参考改一下可用:
create proc crt
as
declare @cyear int
declare @cmonth int
set @cyear=year(getdate())
set @month=year(getdate())
declare @tb varchar(100)
set @tb=cast(@cyear varchar(10))+cast(@cmonth varchar(10))+'表名'
declare @sql varchar(500)
set @sql='select * into '+@tb+' from 原表'
exec(@sql)