区间段月第一天，最后一天，该月年最后一天

DECLARE @START BIGINT
DECLARE @END BIGINT

SET @START=1980
SET @END=2063

DECLARE @Y_TB TABLE(
    YEAR INT
)

DECLARE @M_TB TABLE(
    MONTH INT
)

WHILE @START <= @END
BEGIN
    INSERT INTO @Y_TB
    SELECT @START
    SELECT @START=@START+1
END

SET @START=1
SET @end=12
WHILE @START <=@END
BEGIN
    INSERT INTO @M_TB
    SELECT @START
    SELECT @START=@START+1
END

SELECT START,DATEADD(DAY,-1,DATEADD(MONTH,1,START)) END_DATE  ,DATEADD(DAY,-1,DATEADD(YEAR,1,START)) YEAR_END_DATE FROM (
    SELECT CONVERT(DATETIME,CONVERT(NVARCHAR(4),YEAR)+'-'+CONVERT(NVARCHAR(2),MONTH)+'-01') START FROM @Y_TB A
    FULL JOIN @M_TB B ON 1=1
)A
ORDER BY START