【Trigger】刪除record，更新其它table相對應的值

trigger名稱叫：del_rdr1_record
deleted  --->  表示RDR1被delete的那些記錄
當RDR1 table中record del 時 也會更新其它table相對應的record值

完整：
ALTER TRIGGER [dbo].[del_rdr1_record]
   ON  [dbo].[RDR1]
   AFTER DELETE
AS
BEGIN
 SET NOCOUNT ON;
      Begin
        -- delete RDR1 table中record時觸發並會執行下面的動作 
 declare @OpenCreQty float
        select @OpenCreQty=ISNULL(sum(OpenCreQty),0) from rdr1  where ItemCode in (select ItemCode from deleted) and WhsCode in (select WhsCode from deleted)

        --做更新動作 oitm oitw 兩個Table
        update oitm set U_Total_SD=@OpenCreQty where ItemCode in (select ItemCode from deleted)
        update oitw set u_sales_demand=@OpenCreQty where ItemCode in (select ItemCode from deleted) and WhsCode in (select WhsCode from deleted)
 End

END