1.查询在某段时间内的数据
select * from biao where datum1 between CAST ('2008-01-01 00:00:00' AS smalldatetime) and CAST ('2008-31-12 00:00:00' AS smalldatetime)
2. 查询在某个时间以前(以后>=)的数据
select * from biao where datum1 <= CAST ('2008-31-12 00:00:00' AS smalldatetime)