Home Transaction Isolation Levels
Post
Cancel

Transaction Isolation Levels

Posted 2022-05-19 Updated 2022-06-13 1 min read

  • What is concurrency?

    Concurrency: two or more transactions that read/change shared data at the same time. Isolate our transaction from other transactions

  • Transaction isolation levels

    • READ COMMITTED (default)
    • READ UNCOMMITTED
    • REPEATABLE READ
    • SERIALIZABLE
    • SNAPSHOT
    1
2

          SET TRANSACTION ISOLATION LEVEL
      {READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE | SNAPSHOT}

will add rest later…

SQL, 7. Transactions And Error Handling in SQL Server
sql t-sql concurrency read committed read uncommitted repeatable read serializable snapshot
This post is licensed under CC BY 4.0 by the author.
Recently Updated
Contents