列出區間內的所有日期

  • 56
  • 0

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]