SQL列出區間內的所有日期
DECLARE @SDate datetime,@EDate datetime
set @EDate = @EDate + 0.9999999
--取得日期
;with [DateList]
as
(
select [Date]=@SDate
union all
select [Date]+1
from [DateList]
where [Date]<@EDate-1
)
select [Date]
from [DateList]