First, you should use Constraints to enforce the integrity of the data. The triggers have there place when data integrity cannot be enforced with Constraints.


>I was told to not use trigger at all to control data integrity or other other updating. I am recommended to use stored procedure to do all these.
>
>What is your advice?