How To Use TRY CATCH In SQL Procedure

In this post, we will learn about how to use TRY CATCH in SQL Procedure and store error with error text and procedure with the line number in the table. Here is a simple example for generating the error and store in SQL table. Let's start coding.

source https://www.c-sharpcorner.com/Blogs/how-to-use-try-catch-in-sql-procedure