获取系统某区间所有月份数据、本年度前后近几年年份

SELECT CONVERT(VARCHAR(7),DATEADD(MONTH,number,'2021-01-01'),120) AS YEARMONTH
FROM master..spt_values
WHERE type='P' AND DATEADD(MONTH,number,'2021-01-01')<=GETDATE()

 

select number from master..spt_values WHERE type='P' and number>CONVERT(int,YEAR(GETDATE()))-5 and number<CONVERT(int,YEAR(GETDATE()))+5