7> BEGIN TRY
8> SELECT CONVERT(int, 'ABC') AS ConvertException
9> END TRY
10> BEGIN CATCH
11> IF ERROR_NUMBER() = 123
12> SELECT 'Error 123'
13> ELSE
14> SELECT ERROR_NUMBER() AS ErrorNumber
15> END CATCH
16> GO
ConvertException
----------------
(0 rows affected)
ErrorNumber
-----------
245
(1 rows affected)