这个到底错在哪语句未结束 sql="select * from orderform where issuedate be

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/11 01:31:16

这个到底错在哪
语句未结束
sql="select * from orderform where issuedate between dateadd("m",-3,now()) and now()"
-----------------------------------------------------------------------------------^
我要读取某access数据表中的近三个月内的数据
但是不知道为什么,写完代码,测试时,会提示,该行语句未结束?
我实在找不到出来错在哪,

"select * from orderform where issuedate between dateadd("m",-3,now()) and now()"
一般情况下,双引号引用的字符串中间不能再包含双引号的,单引号引用的字符串中间也不能包含单引号.如果确实要存在的话：
1.使用转义字符
2.单引号和双引号嵌套使用如：
"it is 'saaa'."
所以,在确保你的sql语句没有问题的情况下,可改为：
"select * from orderform where issuedate between dateadd('m',-3,now()) and now()"

SQL 语句 "SELECT * FROM {{table}} WHERE `fleet_end_time` 改写SQL语句,将下面这个语句改写成SELECT-FROM-WHERE的形式. select id from (select * from tree)这个sql语句有什么错吗在SQL语句中USE pubs SELECT DISTINCT title FROM title WHERE price 下面的SQL语句select * from [viwBasket] where tblUser='" + (string sql如何取交集有这样两条sql语句select distinct id from a where id='123'se SQL语句理解 select * from B where (select count(1) as num from A 请问大侠,我要在function（）下写一个动态sql语句,如select * from A WHERE name in String sql = "select * from tb_consumer where account='" + a SQL >select count(*) from Teacher where teacherCode=? and te sql="select discount_value from shop_discount where discount sql="select * from "&data&" where id="&myid&"" 在数据库中没有data 这