定义结果集为rst for i:=1 to rst.recordcount do begin str:='insert into tab_a values('x','rst.field[0].asstring','rst.field[1].asstring',sysdate,'rst.field[2].asstring','rst.field[3].asstring') ' end;
呵呵,不用循环,直接用sql写,循环太慢!
以前就是你现在的这种方式,我嫌它太慢,想直接用sql语句
就是想用SQL语句写但是不会写,^_^
如果你不需要应用程序对结果集进行其他处理,MSSQL可以考虑如下语句: insert into tab_a (a,b,c,d,e,f) select 'x',tablex.b,tablex.c,getdate(),tablex.e,tablex.f from tablex where ...
for i:=1 to rst.recordcount do
begin
str:='insert into tab_a values('x','rst.field[0].asstring','rst.field[1].asstring',sysdate,'rst.field[2].asstring','rst.field[3].asstring') ' end;
insert into tab_a (a,b,c,d,e,f)
select 'x',tablex.b,tablex.c,getdate(),tablex.e,tablex.f
from tablex
where ...