declare @StartDate DATETIME = '${开始日期}'
declare @EndDate DATETIME = '${结束日期}'
SELECT
CONVERT (VARCHAR (100),dateadd(day,n.number,@StartDate),23) AS every_day
FROM
master..spt_values n
WHERE
n.type = 'p'
AND n.number <= DATEDIFF(day, @StartDate, @EndDate) |