Send the following on WhatsApp
Continue to ChatRollback Transaction On Error In SQL Server Stored Procedure https://www.mytecbits.com/microsoft/sql-server/rollback-transaction-error-sql-server-stored-procedure
Rollback Transaction On Error In SQL Server Stored Procedure https://www.mytecbits.com/microsoft/sql-server/rollback-transaction-error-sql-server-stored-procedure