DECLARE @InStartDate DATE='2022-12-12';
DECLARE @InStopDate DATE='2022-12-25';
WITH GEN AS
(
   SELECT @InStartDate AS Start_dated
      UNION ALL
   SELECT DATEADD(DD,1,G.Start_dated)
     FROM GEN AS G
   WHERE G.Start_dated< @InStopDate
)
SELECT G.*
FROM GEN AS G

你可以用这个

你需要从生成一个数字表开始，它需要足够的行来处理开始日期和结束日期之间的每一天，比如：

with Numbers as (
    select 0 as n
    union all
    select n + 1
    from Numbers
    where n < 365
)
select n
from Numbers
option(maxrecursion 0);

给定示例范围后，我觉得365天（一年）就足够了，但调整这个范围很容易（我们将看到）。
有了Numbers表后，可以使用DateAdd()将该金额添加到开始日期：

DECLARE @StartDate date = '20221212'; 

with Numbers as (
    select 0 as n
    union all
    select n + 1
    from Numbers
    where n < 365
)
select DATEADD(day, n, @StartDate)
from Numbers
option(maxrecursion 0)

从这里开始，在WHERE子句中使用EndDate来限制总行数就很简单了：

DECLARE @StartDate date = '20221212'; 
DECLARE @EndDate date = '20221231';

with Numbers as (
    select 0 as n
    union all
    select n + 1
    from Numbers
    where n < DATEDIFF(day, @StartDate, @EndDate)
)
select DATEADD(day, n, @StartDate)
from Numbers
option(maxrecursion 0)