If you want to look at some code just look at the insert, delete, and update triggers in any dbc that you have enabled triggers on. This will give you a good idea about how to use transactions.