-
Contributing Member
Trigger Execution Order
I executed Database Trigger execution order example given in HOW TO's for update statement.
Before update on table and After update on table are executed irrespective of whether update statement updates rows or not?
What is the use of firing these two triggers eventhough not even a single row effected? When do we use these two triggers?
-
Re: Trigger Execution Order
If there is no update statment then the trigger is not going to fire.
-
Junior Member
Re: Trigger Execution Order
Trigger Execution Orders are different according to the Trigger u r using.
There are two types of Triggers generaly used.
1. Application Triggers
2.Database trigger.
Each type of trigger (say application trigger or Database trigger)having different execution order.Pls leave message which trigger u r using..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules