我这样写对吗?高手!拜托!
不是有一条语句可以把数据从一个数据库拷贝插入到另一个具有相同结构的数据库吗,二个数据库不在同一台机子上什么OPENDATASOURCE吗?
我现在是前台销售数据存到后台,如果后台联不上,就联本台,用本台销售后数据在插入传到后台,高手帮我看看呀!
try
posdm.posADOConnection.BeginTrans;
posdm.cmmADOQry.Close;
posdm.cmmADOQry.SQL.Clear;
posdm.cmmADOQry.SQL.Add('select * from OPENDATASOURCE('+''''+'SQLOLEDB'+''''+','+''''+'Data Source=192.168.0.1;User ID=sa;Password='+''''+').AER.dbo.XIAOSHOU');
posdm.cmmADOQry.SQL.Add('select * into AER..XIAOSHOU from OPENDATASOURCE('+''''+'SQLOLEDB'+''''+','+''''+'Data Source=192.168.0.1;User ID=sa;Password='+''''+').AER.dbo.XIAOSHOU');
posdm.cmmADOQry.SQL.Add('insert AER..XIAOSHOU select * from OPENDATASOURCE('+''''+'SQLOLEDB'+''''+','+''''+'Data Source=192.168.0.1;User ID=sa;Password='+''''+').AER.dbo.XIAOSHOU');
posdm.cmmADOQry.ExecSQL;
posdm.posADOConnection.CommitTrans;
showmessage('上传成功');
except
posdm.posADOConnection.RollbackTrans;
showmessage('上传失败');
end;