为序列SQL server生成缺少的年份

-- 创建临时表
CREATE TABLE #Years (Year INT)

-- 查询已有数据表中存在的年份，并插入到临时表中
INSERT INTO #Years (Year)
SELECT DISTINCT YEAR(DateColumn) AS Year
FROM YourTable

-- 定义起始年份和结束年份
DECLARE @StartYear INT = 2000
DECLARE @EndYear INT = 2022

-- 循环遍历年份
WHILE @StartYear <= @EndYear
BEGIN
    -- 判断年份是否存在于临时表中
    IF NOT EXISTS (SELECT 1 FROM #Years WHERE Year = @StartYear)
    BEGIN
        -- 插入缺少的年份到已有数据表中
        INSERT INTO YourTable (DateColumn)
        VALUES (CONVERT(DATE, CONVERT(VARCHAR(4), @StartYear) + '-01-01'))
    END

    SET @StartYear = @StartYear + 1
END

-- 删除临时表
DROP TABLE #Years