填充SQL Server中两个日期之间的缺失日期

CREATE TABLE DateTable (
    DateValue DATE PRIMARY KEY
);

DECLARE @StartDate DATE = '2022-01-01';
DECLARE @EndDate DATE = '2022-12-31';

WHILE @StartDate <= @EndDate
BEGIN
    INSERT INTO DateTable (DateValue) VALUES (@StartDate);
    SET @StartDate = DATEADD(DAY, 1, @StartDate);
END

DECLARE @StartDate DATE = '2022-01-01';
DECLARE @EndDate DATE = '2022-12-31';

SELECT dt.DateValue
FROM DateTable dt
LEFT JOIN YourTable yt ON dt.DateValue = yt.DateColumn
WHERE dt.DateValue BETWEEN @StartDate AND @EndDate
    AND yt.DateColumn IS NULL;