递归方法 使用sql查询生成开始到结束日期之间的所有日期

declare @StartDate DATETIME = ‘2015/05/01’
declare @EndDate DATETIME =’2015/06/03’;

with cte as
(
select @StartDate dday
union all
select dday +1 from cte
where dday < @EndDate
)
select * from cte
option(maxrecursion 0)