Hi

I'm creating some stored procedures which are inserting a set of records into various tables in my database.

I want to wrap each set of inserts in a transaction so only a complete set get added.

How do I make sure that any errors are picked up and stop the transaction being committed.

Thanks