Home

SQL Update in serializable mode no index

Update in serializable mode no index

USE PUBS
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRAN
UPDATE authors
SET contract = 1
WHERE state = 'UT'
EXEC sp_lock2 @@spid
COMMIT TRAN