TRY...CATCH And RAISERROR With Stored Procedure

In this article, we’ll see how to handle the error and raise an error in SQL Server with a stored procedure.

source https://www.c-sharpcorner.com/Blogs/how-to-use-trycatch-inside-sp