T-SQL存储过程之定期备份上月数据

create procedure createNewData
as
begin
--********************
--自动作业
--功能：每个月备份上个月
--脚本编写：邬畏畏
--********************
declare @y int
declare @m int

declare @str varchar(20)
set @y=year(getdate())
set @m=month(getdate()) -1

if @m=0
begin
set @y=@y-1
set @m=12
end

set @str = 'fc_Data_' + convert(varchar(4),@y) + convert(varchar(2),@m)

execute('select * into ' + @str + '  from fc_Data where year(curDate)=' + @y + ' and month(curDate)=' + @m )
execute('delete from fc_data where year(curDate)=' + @y + ' and month(curDate)=' + @m)

end