Using TRY…CATCH to Rollback a Transaction in the Face of an Error With SQL Server 2005′s TRY…CATCH block, Try catch block is used in simple statement with transaction, these types of scripts are greatly simplified. …
Go here to see the original:
Sql And Dot Net: Error Handling using Try Catch in SQL