更新两个sqlserver数据库? 更新两个服务器上的数据?还是更新两个库?如果是后者,可以在SQL表里建立触发器,只要有更新,马上把另一个库的里的内容跟着修改或者增加。 例子: CREATE TRIGGER UP_TR_Users ON [dbo].[Users] FOR update as insert UpDateInfo SELECT 'Users' as TableName,ID AS RECORDID,2 As UpMode,GetDate() As LastUpDate , CompanySN FROM inserted
依我看只能这样: ... for i:=1 to 要添加的数据集的数量 do begin myDataSet.AppendRecord(......); end; ...
更新两个服务器上的数据?还是更新两个库?如果是后者,可以在SQL表里建立触发器,只要有更新,马上把另一个库的里的内容跟着修改或者增加。
例子:
CREATE TRIGGER UP_TR_Users
ON [dbo].[Users]
FOR update
as
insert UpDateInfo SELECT 'Users' as TableName,ID AS RECORDID,2 As UpMode,GetDate() As LastUpDate , CompanySN FROM inserted
...
for i:=1 to 要添加的数据集的数量 do
begin
myDataSet.AppendRecord(......);
end;
...
Try
ADOCNN1.BeginTrans;
....
....
ADOCNN2.BeginTrans;
....
....
ADOCNN1.CommitTrans;
ADOCNN2.CommitTrans;
Except
ADOCNN1.RollbackTran;
ADOCNN2.RollbackTran;
End;