学步园

CREATE TRIGGER tgr_OrderList_delete ON [dbo].[OrderList]
FOR  DELETE 
AS
BEGIN
DELETE PartsList FROM PartsList, deleted   --使用特殊表进行查询删除条件 
WHERE PartsList.OrderNum=deleted.OrderNum
END