CREATE TRIGGER trg_B_del ON B
FOR DELETE
ASbegin
update X set x1=x1-1 where xid in (select dgId from deleted)
end
FOR DELETE
ASbegin
update X set x1=x1-1 where xid in (select dgId from deleted)
end
FOR DELETE
AS
update X set x1=a.x1-1
from x a join deleted b on a.xid=b.dgId
FOR DELETE
ASUpdate X set x1=x1-1 where xid IN (SELECT Distinct dgid FROM Deleted)go