Using try catch in SQL Server stored procedures

A great new option that has been around since SQL Server 2005 is the ability to use the Try..Catch paradigm that exists in other development languages. Doing error handling in SQL Server has not always been the easiest thing, so this option definitely makes it much easier to code for and handle errors.

SQL Server TRY CATCH, RAISERROR and THROW for Error Handling

Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.

Error_Severity()

Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures

Learn how to capture errors in SQL Server stored procedures and gracefully handle errors using Try Catch coding in your stored procedures.

Raising Exceptions and Error Handling with SQL Server THROW

Learn how and why to use THROW in your SQL Server code to be able to better handle errors that may occur during code execution.

Default Raiserror Levels

Getting More Information From the String or Binary Data Truncated Error

Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.

A Lack of Error Handling

Not a lot of people use error handling in their T-SQL code.

Bad Error Handling

ErrorHandling for running or deploying code

Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.