Modifying exception types with XACT_ABORT : XACT_ABORT « System Settings « SQL Server / T-SQL Tutorial

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

4> SET XACT_ABORT ON
5> SELECT POWER(2, 32)
6> PRINT 'This will NOT print!'
7> GO
Msg 232, Level 16, State 3, Server J\SQLEXPRESS, Line 5
Arithmetic overflow error for type int, value = 4294967296.000000.
1>
2>