XACT_ABORT in a stored procedure : XACT_ABORT « System Settings « SQL Server / T-SQL Tutorial

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

6> CREATE PROCEDURE NoRollback
7> AS
8> BEGIN
9>     SET XACT_ABORT ON
10>
11>     BEGIN TRANSACTION
12>         INSERT SomeData VALUES (1)
13>
14>         INSERT SomeData VALUES (1/0)
15>     COMMIT TRANSACTION
16> END
17> GO
1>