Microsoft SQL Server Transaction isolation levels Read Committed
Example
SQL Server 2008 R2
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
This isolation level is the 2nd most permissive. It prevents dirty reads. The behavior of READ COMMITTED depends on the setting of the READ_COMMITTED_SNAPSHOT:
-
If set to OFF (the default setting) the transaction uses shared locks to prevent other transactions from modifying rows used by the current transaction, as well as block the current transaction from reading rows modified by other transactions.
-
If set to ON, the
READCOMMITTEDLOCKtable hint can be used to request shared locking instead of row versioning for transactions running inREAD COMMITTEDmode.
Note: READ COMMITTED is the default SQL Server behavior.
