Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
menu_book Course Curriculum (T-SQL) expand_more
Query Basics
TOP TOP WITH TIES OFFSET FETCH IIF CHOOSE CONCAT STRING_AGG STRING_SPLIT TRY_CAST TRY_CONVERT
Variables & Flow
DECLARE variable SET variable SELECT assignment IF ELSE WHILE BREAK CONTINUE BEGIN END GOTO label RETURN code
Data Changes
OUTPUT clause UPDATE FROM DELETE FROM join MERGE IDENTITY insert SCOPE_IDENTITY SEQUENCE Table value constructor SELECT INTO TRUNCATE TABLE
Transactions & Errors
BEGIN TRANSACTION COMMIT TRANSACTION ROLLBACK TRANSACTION SAVE TRANSACTION @@TRANCOUNT XACT_STATE TRY CATCH THROW RAISERROR SET XACT_ABORT
Stored Programming
CREATE PROCEDURE Procedure parameters OUTPUT parameter CREATE FUNCTION Scalar UDF Inline table-valued function Multi-statement TVF EXECUTE procedure sp_executesql Dynamic parameterization
Window & Analytics
ROW_NUMBER RANK DENSE_RANK NTILE LAG LEAD FIRST_VALUE LAST_VALUE PERCENT_RANK Running aggregate
Temporary Data
Local temp table Global temp table Table variable CTE Recursive CTE CROSS APPLY OUTER APPLY PIVOT UNPIVOT VALUES table constructor
SQL Server Features
Computed column Filtered index Included columns index Temporal table JSON_VALUE OPENJSON FOR JSON PATH XML nodes TRY_PARSE SESSION_CONTEXT
T-SQL / Transactions & Errors

XACT_STATE

Learn XACT_STATE in T-SQL through a focused explanation, a dedicated construct-specific example, an engineering boundary, and a mastery check.

10 min read • Intermediate

XACT_STATE is an atomic T-SQL topic inside Transactions & Errors. This lesson focuses on how the XACT_STATE construct is written, what it changes, and when it is the right tool.

Trace the example line by line. Identify the exact syntax for XACT_STATE, the input state before it runs, and the resulting value, control flow, database state, hardware behavior, or runtime effect afterward. Neighboring lessons use different constructs rather than renamed copies of this one.

Topic-specific example

tsql-04-06-xact-state.sql
tsql Try It Live 
BEGIN TRY BEGIN TRAN; UPDATE Accounts SET balance=balance-10 WHERE id=1; COMMIT; END TRY BEGIN CATCH SELECT XACT_STATE() AS state; IF XACT_STATE()<>0 ROLLBACK; END CATCH;
Edge case / engineering note

For XACT_STATE, test the boundary that belongs to this exact feature rather than a generic failure case. Check invalid or empty input, NULL/unknown state, numeric limits, transaction or exception behavior, synthesis/runtime constraints, ownership/permission rules, or backtracking/control-flow effects where they apply.

Content source & attribution
Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

XACT_STATE Mastery Check →
← PREVIOUS
@@TRANCOUNT
NEXT →
TRY CATCH