Editing ACID (section)

=== Isolation ===
{{Main article|Isolation (database systems)}}
Transactions are often executed [[concurrent computing|concurrently]] (e.g., multiple transactions reading and writing to a table at the same time). [[Isolation (database systems)|Isolation]] ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially. Isolation is the main goal of [[concurrency control]]; depending on the isolation level used, the effects of an incomplete transaction might not be visible to other transactions.<ref>{{Cite web |last=Archiveddocs |date=2012-10-04 |title=Isolation Levels in the Database Engine |url=https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms189122(v=sql.105) |access-date=2023-07-14 |website=learn.microsoft.com |language=en-us}}</ref>