34,838
社区成员




create trigger tri_a_delete on a
for delete
as
delete b from deleted a where a.acc_id =b.acc_id
create trigger my_trig on a for delete
as
delete B from B , deleted t where b.acc_id = t.acc_id
go
[code=SQL]create trigger my_trig on a for delete
as
delete B from B , deleted t where b.acc_id = t.acc_id
go
[/code]CREATE TRIGGER TRI_DEL ON TA
FOR DELETE
AS
DELETE B FROM DELETED WHERE acc_id=DELETED.acc_id
CREATE TRIGGER TRI_DEL
FOR DELETE
AS
DELETE B FROM DELETED WHERE acc_id=DELETED.DELETED