What are the isolation levels available in SQL Server while working with Transactions?

Isolation Levels:

Below are the list of 5 available Isolation levels in SQL Server.

  • Read Uncommitted — This level allows any transaction to fetch records even though there is lock on those particular records.
  • Read Committed — This level does not allow any transaction to fetch records if there is lock on those particular records. This is default Isolation level in SQL Server.
  • Serializable — This level does not allow any transaction to fetch the data only when the other transactions are done with their data modification.
  • Repeatable Read — This level does not allow any transaction to fetch the data which is being changed by another transaction also which is not committed data.
  • Snapshot — This level cannot fetch the data which is modified after the transaction begins. It can fetch the data which is already committed before it starts. 

Happy Reading :)

 

Latest Comments
  1. Dinesh vishe

    Great Explain…
    There is multiple data delete and update in procedure then trancation is used ?

  2. Dinesh vishe

    I created a stored procedure to access data in DB.
    i need to ensure that the stored procedure supports dirty reads. then transcation level is used ?

Leave a Reply

Your email address will not be published. Required fields are marked *