写一个 a 表的触发器，当删除 a 表的时候，删除与 a 表通过 acc_id 字段相关联的表 b，怎么写？

[Zi_Yuan]

写一个 a 表的触发器，当删除 a 表的时候，删除与 a 表通过 acc_id 字段相关联的表 b，怎么写？谢谢！

[快乐_石头]

CREATE TRIGGER TRI_DEL
FOR DELETE
AS
DELETE B FROM DELETED WHERE acc_id=DELETED.DELETED

• 打赏
• 举报

回复 赞

[Zi_Yuan]

写一个 a 表的触发器，当删除 a 表的时候，删除与 a 表通过 acc_id 字段相关联的记录，条件是a.acc_id=b.acc_id，怎么写？谢谢！

• 打赏
• 举报

回复 赞

[快乐_石头]

CREATE TRIGGER TRI_DEL ON TA
FOR  DELETE
AS
DELETE B FROM DELETED WHERE acc_id=DELETED.acc_id

• 打赏
• 举报

回复 赞

[dawugui]

[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]

• 打赏
• 举报

回复 赞

[dawugui]

create trigger my_trig on a for delete
as
   delete B from B , deleted t where b.acc_id = t.acc_id 
go

• 打赏
• 举报

回复 赞

[sdhdy]

create trigger tri_a_delete on a
for delete
as
delete b from deleted a where a.acc_id =b.acc_id 

• 打赏
• 举报

回复 赞

[kn731]

不知道..但是帮你顶!

• 打赏
• 举报

回复 赞