Getting Date Range

Question

I want to get all the information between two given dates, How can I get a range of Date in SQL server with the datatype of "smalldatetime"

I'm expecting to get all the information start from start date to end date

Answer 1

I think you are looking for this :

SELECT * 
from your_table
where date BETWEEN start_date AND end_date