Standard SQL Server transaction usage xact_abort

A very valuable article:

Http://www.sqlstudy.com/ SQL _article.php? Id = 2008060701

One of the keys is set xact_abort on. [I personally think This is the simplest and most effective method]

If try catch is applied, use the following system functions to get the error message in catch:

Error_severity (), error_state (), error_number (),
Error_procedure (), error_line (), error_message ()

Also, when committing or rolling back a transaction, it is critical to judge @ trancount> 0. Otherwise, errors may occur in nested transactions.