Re: transactions

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