select object_id('aa')
go
declare @mm nvarchar(50), @dd nvarchar(50), @cc nvarchar(50),@yy nvarchar(50)
select @cc='beijing_'
select @yy=datename(year,getdate())
select @mm =cast(month(getdate())-1 as varchar)
select @dd=@cc+@yy+@mm
select @dd
exec sp_rename 'aa',@dd
go
go
declare @mm nvarchar(50), @dd nvarchar(50), @cc nvarchar(50),@yy nvarchar(50)
select @cc='beijing_'
select @yy=datename(year,getdate())
select @mm =cast(month(getdate())-1 as varchar)
select @dd=@cc+@yy+@mm
select @dd
exec sp_rename 'aa',@dd
go
declare @month as intset @month = month(getdate())if @month = 1
begin
set @month = 12
set @year = year(getdate()) - 1
end
else
begin
set @month = @month - 1
set @year = year(getdate())
end