SQL Transactions

Transaction control — BEGIN, COMMIT, ROLLBACK, SAVEPOINT, ACID properties. This category documents 28 SQL transactions entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: BEGIN / START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION / ISOLATION LEVEL, AUTOCOMMIT, DEADLOCK, XACT_ABORT, READ ONLY / READ WRITE, WITH (NOLOCK) / READ UNCOMMITTED, PREPARE TRANSACTION (2PC), CHAINED TRANSACTION, Implicit vs Explicit Transaction, Transaction Log (Write-Ahead Log), WITH (ROWLOCK / TABLOCK), SERIALIZABLE Isolation Deep Dive, ACID Properties, Two-Phase Commit (Distributed), Savepoints in Nested Transactions, Transaction Monitoring, MVCC (Multi-Version Concurrency Control), Implicit Transactions (SQL Server), Transaction Log Management, Transaction Deadlock Detection, DBCC OPENTRAN, SET XACT_ABORT ON (SQL Server), CHECKPOINT Process, SQL Server TRANSACTION with SAVE. Not sure where to start? BEGIN / START TRANSACTION and COMMIT are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.