How To Return Error Message In Stored Procedure

Return Error Message In SQL Server Stored procedure

How will you return error message in SQL Server stored procedure? Capturing the exception occurred in a stored procedure and returning the error message to the calling application is important in SQL Server programming. Here is the method to return the error message from a stored procedure.