Figures explicatives

Figure 1 :Exemple de trigger SQL

Create Trigger TotalCommission
  After Insert On Sales
  Referencing New As NewSale
  For Each Row
Begin
  Declare MaxCommission Decimal( 7, 2 )
                        Default( 99999.00 );
  /* $100 Commission per sales transactiob */
  Update  Staff
  Set     Commission * Min( MaxCommission,
          Commission + ( 100 * NewSale.SalesCnt

                    

) )
Where Staff.StaffId = NewSale.StaffId ;
End

Figures 2 & 3 : Consultez l’édition papier …