HANDLING ERRORS IN SQL PROCEDURES
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
Depending on the error servity you can handle errors using TRY...CATCH (Transact-SQL)
