EXEC SQL BEGIN DECLARE SECTION; int id[100]; char name[100][10]; int exist; EXEC SQL END DECLARE SECTION; .......... ......EXEC SQL INSERT INTO CUST_INFO(ID, NAME) VALUES(:id, :name);
實在不行. 在 SQL QUERY Analyzer中copy如下資料 INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('mahe','0.2') INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('zuofa','111') INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('youfa','120') INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('FD','333') INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('BB','444')執行.
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) select 'mahe','0.2' union all select 'zuofa','111' union all select 'youfa','120' union all select 'FD','333' union all select 'BB','444' 执行如上的SQL语句,就会一次性给你插入
int id[100];
char name[100][10];
int exist;
EXEC SQL END DECLARE SECTION; ..........
......EXEC SQL INSERT INTO CUST_INFO(ID, NAME) VALUES(:id, :name);
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('mahe','0.2')
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('zuofa','111')
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('youfa','120')
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('FD','333')
INSERT INTO YOUTABL(YOUNAME,YOUVAUE) VALUES('BB','444')執行.
select 'mahe','0.2'
union all select 'zuofa','111'
union all select 'youfa','120'
union all select 'FD','333'
union all select 'BB','444'
执行如上的SQL语句,就会一次性给你插入