ERROR_SEVERITY function : ERROR_SEVERITY « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. ERROR_SEVERITY

6> BEGIN TRY
7>     SELECT CONVERT(int, 'ABC') AS ConvertException
8> END TRY
9> BEGIN CATCH
10>     DECLARE
11>         @ERROR_SEVERITY INT,
12>         @ERROR_STATE INT,
13>         @ERROR_NUMBER INT,
14>         @ERROR_LINE INT,
15>         @ERROR_MESSAGE VARCHAR(245)
16>
17>     SELECT
18>         @ERROR_SEVERITY = ERROR_SEVERITY(),
19>         @ERROR_STATE = ERROR_STATE(),
20>         @ERROR_NUMBER = ERROR_NUMBER(),
21>         @ERROR_LINE = ERROR_LINE(),
22>         @ERROR_MESSAGE = ERROR_MESSAGE()
23>
24>     RAISERROR('Msg %d, Line %d: %s',
25>         @ERROR_SEVERITY,
26>         @ERROR_STATE,
27>         @ERROR_NUMBER,
28>         @ERROR_LINE,
29>         @ERROR_MESSAGE)
30> END CATCH
31> GO
ConvertException
----------------
Msg 50000, Level 16, State 1, Server J\SQLEXPRESS, Line 24
Msg 245, Line 7: Conversion failed when converting the varchar value 'ABC' to data type int.

(0 rows affected)
1>