ASP SQL中,查询条件为日期字段的一个时间段,或者日期字段为空,怎么写查询

2025-03-03 17:21:40
推荐回答(3个)
回答1:

你的 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"

回答2:

第一个问题: select coursename from course where settime between #2000-092.转化时,跟日期有关的字段,SQL SERVER默认为smalldatetime型,我们最好

回答3:

6577657657