Generate all dates between two date in SQL Server

To get all dates between two date we can use below T-SQL Script:

DECLARE @SDate DATETIME
DECLARE @TDate DATETIME
SET @SDate = '2011-9-01 00:00:00.000'
SET @TDate = '2011-9-30 00:00:00.000'
;WITH CTE AS
(
  SELECT @SDate Date
  UNION ALL
  SELECT Date + 1 FROM CTE WHERE Date + 1 <= @TDate
)
SELECT Date FROM CTE

That’s It.
Enjoy Learning.