THROW

Giao dịch và Xử lý lỗi trong SQL Server

Miriam Antona

Software Engineer

Cú pháp THROW

Microsoft khuyến nghị dùng thay cho RAISERROR.

THROW [ error_number, message, state ][ ; ]

THROW - không tham số

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 - nhập nhằng

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 - nhập nhằng

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 - có tham số

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 - có tham số

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         |

Ayo berlatih!

Giao dịch và Xử lý lỗi trong SQL Server