Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Resignals an exception condition.
RESIGNAL [ exception-name ]
Within an exception handler, RESIGNAL allows you to quit the compound statement with the exception still active, or to quit
reporting another named exception. The exception is handled by another exception handler or returned to the application.
The RESIGNAL statement is part of optional SQL/2008 language feature P002, "Computational completeness".
The RESIGNAL statement cannot be used in Transact-SQL compound statements and procedures.
The following fragment returns all exceptions except SQLSTATE 52003 to the application.
DECLARE COLUMN_NOT_FOUND EXCEPTION
FOR SQLSTATE '52003';
WHEN COLUMN_NOT_FOUND THEN
SET message='Column not found';
WHEN OTHERS THEN