Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
SQL Error Actions: What SQL Server Does After an Error
SQL error actions decide what runs after an error in SQL Server. This post shows statement termination, scope abortion, batch termination, connection termination and XACT_ABORT, with real results from three small stored procedures. It also covers what each reaction does to an open transaction and how TRY…CATCH changes the outcome.
Table Variables and Transactions in SQL Server: SQL in Sixty Seconds #007
Table variables and transactions do not mix the way temporary tables do, because a ROLLBACK leaves the rows in a table variable. The tests here cover a full rollback, a savepoint, a failed statement and a logging pattern, all on SQL Server 2025.
T-SQL Errors and Reactions in SQL Server: SQL in Sixty Seconds #002
T-SQL errors and reactions are the subject of this early SQL in Sixty Seconds episode with Rick Morelan. The tests here show which errors stop one statement, which stop the whole batch, and how XACT_ABORT, TRY CATCH and THROW change the reaction.
Accelerated Database Recovery Quiz: Why Did the Rollback Finish at Once?
This Accelerated Database Recovery Quiz asks how long a rollback takes when ADR is on. The answer is almost no time, and a tested script measures the same rollback with ADR off and on. It also shows what ADR costs.
Table Variables vs Temporary Tables Quiz: Which Survives a Rollback?
This Table Variables vs Temporary Tables Quiz inserts one row into each, then rolls back. The table variable keeps its row and the temporary table loses it. A tested script proves it, and two more scripts show a rollback-proof log and the statistics gap.
OUTPUT Clause Quiz: What Do inserted and deleted Hold?
This OUTPUT Clause Quiz raises a price from 10 to 12 and asks which two values come back. The answer is 10 and 12, because deleted holds the old row and inserted the new one. A tested script proves it and shows OUTPUT with INSERT, DELETE and an audit table.