/*首先建立一個刪除型觸發器*/
CREATE trigger d_orders
ON orders
FOR DELETE
AS
/*顯示信息代表觸發器執行*/
PRINT 'DELETE trigger on the orders table is executing…'



/*聲明一個臨時變量用來存儲將要刪除表的順序*/
DECLARE @product_id char (4 ),
@mesg varchar (40)

/*獲得將要刪除的產品的信息*/
SELECT @product_id = productid
FROM deleted
GROUP BY productid

/*刪除產品記錄*/
SELECT @mesg='deleting products'+ @product_id
PRINT @mesg
DELETE products
WHERE productid=@product_id