deleteordertrigger.sql

来自「完成一个网上书店系统」· SQL 代码 · 共 9 行

--delete from Orders where OrderID=5
create trigger deleorder
on Orders
for delete
as
delete from OrderContent
where OrderID in(select OrderID from Orders)