Catch Error Functions

ERROR_NUMBER(): Returns a number associated with the error.
ERROR_SEVERITY(): Returns the severity of the error.
ERROR_STATE(): Returns the error state number
ERROR_PROCEDURE(): Returns the name of the stored procedure or trigger in which the error occurred.
ERROR_LINE(): Returns the line number inside the failing routine that caused the error.
ERROR_MESSAGE(): Returns the complete text of the error message. The text includes the values supplied for any substitutable parameters, such as lengths, object names, or times.