--你给recorder_date字段加索引
go
create clustered index recorder_date_Fee_Receipt-ind on table Fee_Receipt(recorder_date)
然后在查询一下
select * from Fee_Receipt肯定会很快了

------解决方案--------------------
SELECT * FROM Fee_Receipt
WHERE (recorder_date >= '2011-09-1') AND (recorder_date < '2011-10-1')

就能很快出结果吗?

求高人



------解决方案--------------------
recorder_date 不是datatime数据吗?

------解决方案--------------------
2012/9/1 
或
convert试试  




------解决方案--------------------
recorder_date字段是datetime类型吗？