SQL Server TRY CATCH – Handling Exception in Stored Procedure

The TRY CATCH block is used to handle exceptions in Transact-SQL code .