access升级到sql server之后的问题
rs2.open "select * from shop_action where (datediff('d',fhsj,"&day2&")>=0) and (datediff('d',"&day1&",fhsj)>=0) and (bookid="&rs("bookid")&")",conn,1,1
大家帮我看看。这里面有语法错误吗!!!!系统老是提示
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
第 1 行: '#' 附近有语法错误。
/admin/tjbb2.asp,行 52