Hi Salvatore,

Put simply:-

You can use one (default) transaction for all operations.... if you do then
any commit or rollback will occurr on that transaction, and all selects,
updates, and inserts will be commited or rolled back.

If you want to use the full power of transactions then you split the
operations up and use seperate transactions. So that updates, inserts and
selects occur on seperate transactions, hence the commits and rollbacks are
constrained to those transactions elements.

I hope this helps

Andy