如果是2000可以在设置关系时设置联级更新、联级删除
你也可以通过触发器来做如同步两个不同数据库的不同表:CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert db2..tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
go
你也可以通过触发器来做如同步两个不同数据库的不同表:CREATE TRIGGER 名1 ON dbo.tabMain
FOR INSERT
AS
insert db2..tabSlave select * from inserted
goCREATE TRIGGER 名2 ON dbo.tabMain
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
goCREATE TRIGGER 名3 ON dbo.tabMain
FOR delete
AS
delete db2..tabSlave where 编号 in (select 编号 from deleted)
go
add constraint constraintname foreign key(column1) references 从表(column2) on
update cascade on delete cascade
go
create trigger triggername
on 从表
for update
as
begin
update 主表 set 主表.column1=从表.column2 from 从表 where 主表.column1=
inserted.column2
end
create trigger triggername
on 从表
for update
as
begin
update 主表 set 主表.column3=inserted.column4 from inserted where 主表.column1=
inserted.column2
end
删除时:
create trigger triggername
on 从表
for delete
as
begin
delete 主表 from deleted where 主表.column1=
deleted.column2
end