SQL Transaction Example: How to use Transaction in SQL Server
Microsoft Sql Server Tutorials: Rollback Transaction in SQL Server
Rollback Transaction On Error In SQL Server Stored Procedure | My Tec Bits
Error Handling in SQL Server with Try Catch
SQL SERVER - Msg 1206, Level 18, State 118 - The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction - SQL Authority with Pinal Dave