数据库获取本年所有月份

**

Oracle写法

select to_char(add_months(sysdate,-(select to_char(trunc(sysdate),‘MM’)from dual )+level ),‘YYYY_MM’) as t_date
from dual connect by level<=12
**

SqlServer写法

select convert(varchar(7),dateadd(mm,t.number,dateadd(year,datediff(year,0,getdate()),0)),120)
from (
select number from master…spt_values where type=‘p’
) t where t.number<12

**

**