删除A表数据就删除B表字段X和A表被删数据字段X相同的数据:create trigger tr_a_delete
on a
for delete
asset nocount on
delete b
from deleted d
where b.x=d.x
set nocount off
go
on a
for delete
asset nocount on
delete b
from deleted d
where b.x=d.x
set nocount off
go
on b
for delete
asset nocount on
update a
set y=a.y-d.x
from deleted d,a
where a.key=d.key
set nocount off
go