This ensures solid SQL Statements and fast execution time. Stored procedures are fantastic for maintaining data integrity. Good data integrity always translates into good response times. Triggers Triggers are very similar to stored procedures in that they also reside in the database itself. They too are precompiled and have a very similar structure.
Triggers execute automatically based on a particular action to a table.
The answer - triggers can be used for anything from audit trails to data validation. A trigger on a table is considered to be part of any statement run against that table. It becomes almost impossible for someone to corrupt your data. As we said before, good data means good response times. If you need to maintain data integrity, you can move all validation into triggers and take that burden off the client machine.