create proc p
as
declare @tbn nvarchar(50)
declare @sql nvarchar(4000)
set @sql='insert into table tab_1 select * from '
set @tbn='tab_'
if day(getdate())=20
select @sql=@sql+@tbn+right(convert(char(6),getdate(),112),4)
select @sql
--exec(create proc p
as
declare @tbn nvarchar(50)
declare @sql nvarchar(4000)
set @sql='insert into table tab_1 select * from '
set @tbn='tab_'
if day(getdate())=20
select @sql=@sql+@tbn+convert(char(4),getdate(),112)
select @sql
--exec(@sql)
goexec pdrop proc p
as
declare @tbn nvarchar(50)
declare @sql nvarchar(4000)
set @sql='insert into table tab_1 select * from '
set @tbn='tab_'
if day(getdate())=20
select @sql=@sql+@tbn+right(convert(char(6),getdate(),112),4)
select @sql
--exec(create proc p
as
declare @tbn nvarchar(50)
declare @sql nvarchar(4000)
set @sql='insert into table tab_1 select * from '
set @tbn='tab_'
if day(getdate())=20
select @sql=@sql+@tbn+convert(char(4),getdate(),112)
select @sql
--exec(@sql)
goexec pdrop proc p
begin
declare @aa varchar(10)
declare @sql varchar(1000)
select @aa=substring(convert(char(8),getdate(),112),3,4)
select @sql='insert into table tab_1 select * from tab_'+@aa
exec (@sql)
end
然后再建立一个作业,执行上面的这段语句就好了