‘壹’ ASP sql中，查询条件为日期字段的一个时间段，或者日期字段为空，怎么写查询
你的 or and 写的不对
sql_design = "Select * From pro_score Where (hen is null) Or ( Between '"&month_from&"' And '"&month_to& '"&month_to&"'And designer like '%"&Sagittarius&"%' ) Order By hen Desc"
‘贰’ asp sqlserver通过表单查询两个日期内的记录
select*FROM登记表where派单时间between'"&&R1&"'and'"&R2&"'