SQL server:如何从具有开始和结束时间的表生成日期范围

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

SELECT DATEADD(DAY, Number - 1, @StartDate) AS DateRange
FROM (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS Number
    FROM sys.columns
) AS Numbers
WHERE DATEADD(DAY, Number - 1, @StartDate) <= @EndDate;

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

WITH DateRange AS (
    SELECT @StartDate AS Date
    UNION ALL
    SELECT DATEADD(DAY, 1, Date)
    FROM DateRange
    WHERE DATEADD(DAY, 1, Date) <= @EndDate
)
SELECT Date
FROM DateRange;