ASP insert语句

来源：百度知道编辑：UC知道时间：2024/05/20 12:42:57

sql="insert into sec_visit(inout_seq,create_date,create_by,isit_card_no,state_flag,gate_flag,nationality,identification_no,visit_name,company_name,visit_tel_no,car_no,visit_in_date,visit_out_date,visit_date,visit_purpose,dest_dept,dest_emp_name,together_flag,dest_tel,other,activity,create_by) values (’"&INOUT_SEQ&"’,’"&CREATE_DATE&"’,’"&CREATE_BY&"’,’"&Isit_card_no&"’,’"&STATE_FLAG&"’,’"&GATE_FLAG&"’,’"&NATIONALITY&"’,’"&IDENTIFICATION_NO&"’,’"&VISIT_NAME&"’,’"&COMPANY_NAME&"’,’"&VISIT_TEL_NO&"’,’"&CAR_NO&"’,’"&VISIT_IN_DATE&"’,’"&VISIT_OUT_DATE&"’,’"&VISIT_DATE&"’,’"&VISIT_PURPOSE&"’,’"&DEST_DEPT&"’,’"&DEST_EMP_NAME&"’,’"&TOGETHER_FLAG&"’,’"&DEST_TEL&"’,’"&CREATE_BY&"’)"
inout_seq=inout_seq.nextval
create_date=request.form("create_date")
creat

values (’"&INOUT_SEQ&"’,’"&CREATE_DATE&"’,’"&CREATE_BY&"’,’"&Isit_card_no&"’,’"&STATE_FLAG&"’,’"&GATE_FLAG&"’,’"&NATIONALITY&"’,’"&IDENTIFICATION_NO&"’,’"&VISIT_NAME&"’,’"&COMPANY_NAME&"’,’"&VISIT_TEL_NO&"’,’"&CAR_NO&"’,’"&VISIT_IN_DATE&"’,’"&VISIT_OUT_DATE&"’,’"&VISIT_DATE&"’,’"&VISIT_PURPOSE&"’,’"&DEST_DEPT&"’,’"&DEST_EMP_NAME&"’,’"&TOGETHER_FLAG&"’,’"&DEST_TEL&"’,’"&CREATE_BY&"’)"
这后面不对
values ('"& INOUT_SEQ &"','"& CREATE_DATE &"'后面的自己改了

ASP insert语句 asp中 insert into语句 asp中 insert语句出错 asp sql INSERT 语句约束冲突？？ ASP中Insert into 语句错误 INSERT INTO 语句的语法错误。asp asp.net insert语句的写法 ASP INSERT INTO 语句的语法错误 insert 语句 ASP里面insert 语句要怎么写啊？