SQL生成连续日期

SELECT DISTINCT CONVERT
( VARCHAR ( 7 ), DATEADD( MM, NUMBER, CONVERT ( datetime, '2018-01-01', 20 )), 23 ) AS dd
FROM
MASTER..SPT_VALUES
WHERE
TYPE = 'P'
AND DATEADD(
mm,
NUMBER,
CONVERT ( datetime, '2018-01-01', 20 )) <= CONVERT (
datetime,
'2018-12-12',
20)

 

 

连续年