THROW

Transactions et gestion des erreurs dans SQL Server

Miriam Antona

Software Engineer

Syntaxe de THROW

Recommandée par Microsoft plutôt que l'instruction RAISERROR.

THROW [ error_number, message, state ][ ; ]

THROW - sans paramètres

BEGIN TRY
    SELECT price/0 from orders;
END TRY
BEGIN CATCH
    THROW;    
    SELECT 'This line is executed!' as message;
END CATCH

(0 rows affected) 
Msg. 8134, Level 16, State 1, Line 2
Divide by zero error encountered.

THROW - ambiguïté

BEGIN TRY
    SELECT price/0 from orders;
END TRY
BEGIN CATCH
    SELECT 'This line is executed!'
    THROW;
END CATCH

| THROW                  |
|------------------------|
| This line is executed! |

THROW - ambiguïté

BEGIN TRY
    SELECT price/0 from orders;
END TRY
BEGIN CATCH
    SELECT 'This line is executed!';
    THROW;
END CATCH

| (No column name)       |
|------------------------|
| This line is executed! |

(0 rows affected) 
(1 rows affected)
Msg. 8134, Level 16, State 1, Line 2
Divide by zero error encountered.

THROW - avec paramètres

THROW error_number, message, state [ ; ]

THROW 52000, 'This is an example', 1;

Msg. 52000, Level 16, State 1, Line 1
This is an example

THROW - avec paramètres

BEGIN TRY
    IF NOT EXISTS (SELECT * FROM staff WHERE staff_id = 15)
        THROW 51000, 'This is an example', 1;
END TRY
BEGIN CATCH
    SELECT ERROR_MESSAGE() AS message;
END CATCH

| THROW                      |
|----------------------------|
| This is an example         |

Passons à la pratique !

Transactions et gestion des erreurs dans SQL Server