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