deleteordertrigger.sql

完成一个网上书店系统

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