SQL Repeatable read mode

SQL

Download (.zip)

USE PUBS
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRAN
SELECT * FROM authors
WHERE au_lname = 'Ringer'
EXEC sp_lock2 @@spid
COMMIT TRAN

SQLDefault lock mode Repeatable read mode serializable mode
SQLUpdate in serializable mode no index Update in serializable mode with index