How to extract records by T-SQL date range?

Question

Transact SQL

Microsoft Documentation:
https://docs.microsoft.com/ru-ru/sql/t-sql/languag...

Quote:

The following example returns rows where datetime values ​​are between '20011212' and '20020105' inclusive.

SELECT BusinessEntityID, RateChangeDate  
FROM HumanResources.EmployeePayHistory  
WHERE RateChangeDate BETWEEN '20011212' AND '20020105';

Nothing actually happened.
Did the request - produces only the last record by date.

SELECT * FROM [Таб1]
WHERE ([Id] = '10') AND ([Дата] BETWEEN '2020-11-09 00:00:00.000' AND '2020-10-10 00:00:00.000')

So how can you raise records between a certain date range?
datetime data type.

Answer 1

The date representation depends on the settings.

SELECT * FROM [Таб1]
WHERE ([Дата] BETWEEN '20201109' AND '20201010')