SQL Server uses exception handling to debug stored procedures

(1) error_number (): number of returned errors.

(2) error_severity (): returns the error severity level.

(3) error_state (): returns the error Status Number.

(4) error_procedure (): returns the name of the stored procedure or trigger with an error location.

(5) error_line (): ReturnProgramThe row number that causes the error.

(6) error_message (): returns the complete text of the error message. The error content includes the value of replaceable parameters, such as length, object name, or time.

You can use query analyzer to test SQL Server.