时间函数用法

declare @tmSuffix datetime
declare @curYear  varchar(2)
declare @curMonth varchar(2)

-- 当前数据库名
declare @strCurDBName varchar(30)
select @strCurDBName = name from master..sysDataBases 
where dbid = (select dbid from master..sysProcesses where spid = @@spid)

-- 最近第一个月
declare @strLastOne varchar(256)
set @tmSuffix = getdate()
set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)
set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)

-- 示例：当前数据库名DataBase,则历史数据库名格式为DataBase_1305,DataBase_1304
set @strLastOne = @strCurDBName+ '_' + @curYear + @curMonth

-- 最近第二个月
declare @strLastTwo varchar(256)
set @tmSuffix = dateadd(month, -1, @tmSuffix)
set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)
set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)
set @strLastTwo = @strCurDBName + '_' + @curYear + @curMonth

-- 最近第三个月
declare @strLastThree varchar(256)
set @tmSuffix = dateadd(month, -1, @tmSuffix)
set @curYear  = right(100 + DATEPART(year , @tmSuffix), 2)
set @curMonth = right(100 + DATEPART(month, @tmSuffix), 2)
set @strLastThree = @strCurDBName + '_' + @curYear + @curMonth