Dennis Gearon <gearond@cvc.net> writes:
> 1/ Does a procedure take place all in one transaction?
Yes. If you're not using BEGIN/END explicitly each query is its own
transaction.
> 2/ If I am updating/deleting/inserting into two tables, and both tables have triggers on them to
> check the relationship of the data between the tables, any way of knowing which trigger will fire
> first at the end of the transaction?
I'm not sure about this one--do the docs say anything?
-Doug