In a table I have two triggers. When it is called for the first time the first trigger does not fires while the second trigger's got fired. On the next call both first and second trigger action take place. So in my case when calling the trigger first time the first trigger should be executed then the second one. Any suggestions?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
If I am understanding your question correctly, you are looking for the
(Note: this only applies to AFTER triggers, and cannot be used with INSTEAD OF triggers)