System Settings MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Settings
  4. XACT_ABORT in a stored procedure
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>