sqlserver 2008从一张表中查找出在这两个日期（字段为datetime类型）范围内的记录

求sql语句！！！sqlserver 2008从一张表中查找出在这两个日期（字段为datetime类型如2015-07-14 09:22:22.343）范围内的记录~

select * from tab t where t.time between time1 and time2

select * from table where 你的字段 between '2014-1-1' and '2016-1-1'

select * from table where time1 between time1 and time2

between 限定符

SELECT * FROM Books WHERE PublishDate BETWEEN '2015-05-01' AND '2015-05-05'

.SELECT * FROM Books WHERE PublishDate BETWEEN time1 AND time2