根据当前日期往前推12个月得到每月月份及年份

效果就是：
col_name    data_month     data_year
    0            4            2018
    0            5            2018
    0            6            2018
    0            7            2018
    0            8            2018
    0            9            2018
    0           10            2018
    0           11            2018
    0           12            2018
    0            1            2019
    0            2            2019
    0            3            2019

--定义临时表
	declare @tempTable2 table
	(
		col_name nvarchar(20),
		data_month nvarchar(20),
		data_year nvarchar(20)
	)
--定义临时表
	insert into @tempTable2 
	SELECT
		0 as col_name,month(dateadd(mm, number, dateadd(mm,-12,getdate()))) AS data_month,year(dateadd(mm, number, dateadd(mm,-12,getdate()))) AS data_month
	FROM
		master..spt_values n
	WHERE
		n.type = 'p'
	AND n.number <= 12

select * from @tempTable2

同理如果需要得到当前日期往前推7天，稍加改造也可以实现