查询当年所有月份

WITH t AS (
	SELECT CONVERT
		(
			VARCHAR ( 7 ),
			dateadd( mm, t.number, dateadd( YEAR, datediff( YEAR, 0, getdate( ) ), 0 ) ),
			120 
		) MONTH, realMonth=(number+1)
	FROM
		( SELECT number FROM master..spt_values WHERE type = 'P' AND number >= 0 AND number < 13 ) t 
	WHERE
		YEAR ( dateadd( mm, t.number, dateadd( YEAR, datediff( YEAR, 0, getdate( ) ), 0 ) ) ) = YEAR ( getdate( ) ) 
	) SELECT * from t