级联更新和级联删除:alter table mylocation
add constraint fk_mylocation_myname foreign key(myname) references myname(name)
on update cascade on delete cascade
alter table 表2
add constraint fk_mylocation_myname foreign key(字段1,字段2)references 表1(字段1,字段2)
on update cascade on delete cascade
add constraint fk_mylocation_myname foreign key(myname) references myname(name)
on update cascade on delete cascade
alter table 表2
add constraint fk_mylocation_myname foreign key(字段1,字段2)references 表1(字段1,字段2)
on update cascade on delete cascade
FOR update
AS
update db2..tabSlave set 列=aa.列 from inserted aa where aa.编号=db2..tabSlave.编号
tab1 table2
--------- ------------
ID Name ID way
1 'co' '1' 'aaa'
4 'ha' '1' 'bbb'
5 'ca' '1' 'ccc'
7 'yt' '2' 'iii'
====================================
我想写一个存储过程
更改 Tabl1 的 某个ID的值,并且和此ID有链接的ID值也随之改变
for update
as
update table2 set way=b.name from table2 a inner join tabl1 on a.id=b.id
go