Read orders with date range

Gets orders within a date range. Supply StartDate and EndDate in the WITH clause; use literal dates (e.g. 2020-01-01) or relative date functions (see the next example).

SELECT * FROM Orders WITH (StartDate='2020-01-01', EndDate='2021-12-31')