在QUERY1中执行类似如下的SQL insert into DestDatabaseName.dbo.TableName(Field1, Field2, ...,FieldN) select z.Field1, z.Field2, ..., z.FieldN from SourceDatabaseName.dbo.TableName z
ado或bde.分别读出数据写到心数据库中不就行了?字段类型要注意。
to Zhymax(蓝点) 请说详细点,或负上代码好吗?谢谢!
with ADOQuery1 do begin sql.Add('select * from t_a'); open; while not eof do begin ADOQuery2.sql.Clear ADOQuery2.sql.Add('insert into t_b(字段名) values('+ 字段值 +')') ADOQuery2.ExecSQL end; next; end; Close; end;
insert into DestDatabaseName.dbo.TableName(Field1, Field2, ...,FieldN)
select z.Field1, z.Field2, ..., z.FieldN
from SourceDatabaseName.dbo.TableName z
请说详细点,或负上代码好吗?谢谢!
begin
sql.Add('select * from t_a');
open;
while not eof do
begin
ADOQuery2.sql.Clear
ADOQuery2.sql.Add('insert into t_b(字段名) values('+ 字段值 +')')
ADOQuery2.ExecSQL
end;
next;
end;
Close;
end;