Re: trigger firing order

> > does the post trigger on A wait until post trigger on B is
> executed? -> > this seems intuitive to me.
>
> How can it wait until the trigger on B is executed if the trigger on
> B doesn't
> actually get triggered until someone updates B and it's the trigger
> on A
> doing the update?

trigger A executes until it updates table B, at which point it does it
pause execution until the post update trigger on table B completes, and
then trigger A resumes at the next statement.

____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/