Hi,
I would like to know expert opinion..on when to use triggers?
Also,should triggers be used in these scenarios..
1. Say A sale transaction takes place,which is inserted into
transaction table..now this affects account balance of customer which
is stored in another table..
should trigger be used to update customer balance on insert of
transaction table..

vishy