Access与Mssql怎么查询日期的范围
Access:
sql=select * from table where pubtime between #2008-1-5# and #2008-5-18#
Mssql:
sql=select * from table where pubtime between '2008-1-5' and '2008-5-18'
sql=select * from table where pubtime between #2008-1-5# and #2008-5-18#
Mssql:
sql=select * from table where pubtime between '2008-1-5' and '2008-5-18'