SQL server数据库触发器和存储过程

Question

SQL server数据库
触发器和存储过程

When delete tuples of table user, please delete the tuples of cards , all tuples of borrowinfo by the users.

delimiter &&

create trigger t1 before delete
on Users for each row
begin
delete from borrowinfo where borrowinfo.BI_CID=(select cards.CID from cards where cards.C_UID = OLD.UID);
delete from cards where cards.C_UID = OLD.UID;
end
&&

数据库建立的脚本文件
https://download.csdn.net/download/weixin_44882124/87341827

Answer 1

• 文章：SQL Server 存储过程和触发器 中也许有你想要的答案，请看下吧