1/ Does a procedure take place all in one 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?