access的insert语句可以嵌套select语句吗? 我该怎么改下面的语句?
来源:百度知道 编辑:UC知道 时间:2024/05/24 10:51:19
INSERT INTO NC_SoftList (softname,context,homepage,softtime,classid,softsize,impower,Languages,runsystem,star,isbest,isupdate,isaccept) values
('test','test','test',CDate('2007-06-06 06:39:39'),SELECT NC_Classify.ClassID FROM NC_Classify where classname='广告排行','test','test','test','test','3','1','1','1')
('test','test','test',CDate('2007-06-06 06:39:39'),SELECT NC_Classify.ClassID FROM NC_Classify where classname='广告排行','test','test','test','test','3','1','1','1')
这样似乎不行
INSERT INTO NC_SoftList (softname,context,homepage,softtime,classid,softsize,impower,Languages,runsystem,star,isbest,isupdate,isaccept) select
('test','test','test',CDate('2007-06-06 06:39:39'),NC_Classify.ClassID,'test','test','test','test','3','1','1','1' FROM NC_Classify where classname='广告排行')
vc与ACCESs的连接,insert语句
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
access中insert into 语句问题
求 access insert 语句 超简单...
SQl 的INSERT语句
SQL的 INSERT语句
运行写入ACCESS数据库时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
连接access数据库报错说insert的语句有错,请帮忙看一下
Access数据库能使用insert语句进行插入吗?