access, sql asp.net

access中查询介于两个日期间的数据

select column_name(s) from TableName where column_name between #2010-3-1# and #2010-5-30#

在access创建模糊查询时要用*表示

eg:Select * from table where txtTitle like '*家*'

动态 查询日期的话   

select column_name(s) from TableName where column_name between [@StarTime] and [@EndTime]

sql

select  column_name(s) from table_name  where column_name  between value1 and value2