SQL Server between and

1, with between and query time

SELECT * FROM dbo. CheckInOut where userid= ' 17953 ' and checktime between ' 2013-03-16 ' and ' 2013-03-21 '

The database has March 31 of data records, but with between and this writing is not found out

You can find it in this form.

SELECT * FROM dbo. CheckInOut where userid= ' 17953 ' and checktime between ' 2013-03-16 ' and DATEADD (day,1, ' 2013-03-22 ')

2, two SQL statements results are not the same, the first one does not query the results, the second can query the results, you should put small numbers in front

SELECT *from t_portgrant where stageid=73 and portprice between and 100
SELECT *from t_portgrant where stageid=73 and portprice between and 270

SQL Server between and