SQL Update locks

SQL

Download (.zip)

USE PUBS
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
BEGIN TRAN
UPDATE authors
SET contract = 0
WHERE au_lname = 'Ringer'
EXEC sp_lock2 @@spid
ROLLBACK TRAN

SQLCursor grant update permission Locks for table creation row locks
SQLsp_blockinglocks Update in place Update in serializable mode no index
SQLUpdate in serializable mode with index Update locks