Examples of SQL transaction procedures for sales tracking or a financial database
Depending on the complexity of the database design you would probably need to use transacations to maintain data consistency between tables as you change data within the system.

Any examples would be very basic as every database schema would be different.  This is where having a database or data architect comes in handy for a project.