HANDLING ERRORS IN SQL PROCEDURES

[femola]

How can I catch an error in a procedure and the procedure will continue running to the end without failing.

Usually a procedure fails when it encounters an error during the execution of the procedure. but there is a way that you can add a condition to the procedure to write the error somewhere and the procedure will continue to the end without aborting

[#2 · Accepted solution]

Depending on the error servity you can handle errors using TRY...CATCH (Transact-SQL)