Answers for "How to get all dates between date range in SQL query"

sql between date range

SELECT * FROM Orders
WHERE OrderDate BETWEEN '2021-01-01' AND '2021-07-10';

sql list dates between two dates

DECLARE @MinDate DATE = '20140101',
        @MaxDate DATE = '20140106';

SELECT  Date
FROM    dbo.Calendar
WHERE   Date >= @MinDate
AND     Date < @MaxDate;