f0ddf54b_ction_and_Locks_in_MS_SQL_2008__READ_COMMITTED
[Lock TYPE] Holds Lock to end of TRANS [READ UNCOMMITTED] Lowest level [REPEATABLE READ] YES [SERIALIZABLE] Yes [READ COMMITTED SNAPSHOT] – [SNAPSHOT] – [READ COMMITTED] 
NO
N o
Y e s
N O
NotNullOrEmpty: Transaction and Locks in MS SQL 2008
READ COMMITTED