THROW

Description

Implements error handling for Transact SQL. A group of Transact-SQL statements can be enclosed in a TRY block. If an error occurs in the TRY block, control is usually passed to another group of statements that is enclosed in a CATCH block.

Sample Source Patterns

The following example details the transformation for THROW statement without custom message.

SQL Server

Input

CREATE PROCEDURE THROW_PROCEDURE AS
BEGIN TRY
    SELECT 1/0;
END TRY
BEGIN CATCH
    THROW;
END CATCH

Output

[S0001][8134] Line 3: Divide by zero error encountered.

Snowflake SQL

Input

CREATE OR REPLACE PROCEDURE THROW_PROCEDURE ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
    BEGIN
        BEGIN
            SELECT
                TRUNC( 1/0);
        EXCEPTION
            WHEN OTHER THEN
                LET DECLARED_EXCEPTION EXCEPTION;
                RAISE DECLARED_EXCEPTION;
        END;
    END;
$$;

Output

-20000 (P0001): Uncaught exception of type 'DECLARED_EXCEPTION' on line 9 at position 16

The following example details the transformation for THROW statement with a custom message.

SQL Server

Input

CREATE PROCEDURE THROW_PROCEDURE AS
BEGIN TRY
    SELECT 1/0;
END TRY
BEGIN CATCH
    DECLARE @ERROR_MSG VARCHAR(max) = 'DIVISION BY 0';
    THROW  50000, @ERROR_MSG, 1;
END CATCH

Output

[S0001][50000] Line 7: DIVISION BY 0

Snowflake SQL

Input

CREATE PROCEDURE THROW_PROCEDURE AS
BEGIN TRY
    SELECT 1/0;
END TRY
BEGIN CATCH
    DECLARE @ERROR_MSG VARCHAR(max) = 'DIVISION BY 0';
    THROW  50000, @ERROR_MSG, 1;
END CATCH

Output

ERROR NUMBER: 50000
MESSAGE: DIVISION BY 0
STATE: 1

• For THROW statements without a custom message, the default message from SQL Server and Snowflake may be different.

Related EWIs

No related EWIs.