sql server查询该年每一天

DECLARE @StartDate DATETIME,@EndDate DATETIME
SELECT @StartDate='2024-01-01',@EndDate='2024-12-31';

WITH DateList AS (
SELECT @StartDate AS DateValue
UNION ALL
SELECT DATEADD(DAY, 1, DateValue)
FROM DateList
WHERE DateValue <= @EndDate
)
SELECT DateValue 日期, datename(weekday, DateValue) 星期,DATEPART(WEEKDAY,DateValue)-1 weekday FROM DateList
WHERE 1=1 -- and DATEPART(WEEKDAY,DateValue)-1=3
OPTION (MAXRECURSION 0);