Re: Which trigger fires first?

i thought the sequence was delete THEN insert.... that is from my MSSql learning... it seemed that updates were tricks, like a delete followed by an insert.... at least at the trigger level, which is why you had "on delete" and "on insert, update" ....

brent douglas, ncr

Peter Laursen wrote in message <01beda71$8e139440$2c289a0a_at_apollo>...
>If there exists two triggers on a table that are both 'before insert or
>update' how can I know which trigger fires first?
>Can I specify a sequence, ie tell the db i want this trigger to fire first?
>
Received on Mon Aug 02 1999 - 13:37:17 CDT