SQL Update in serializable mode with index

SQL

Download (.zip)

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

SQLCorrelated subquery with derived table Cursor grant update permission Cursor vs join
SQLDecode sysconstraints Default lock mode Diff intervals
SQLError checking in proc Error checking in xact Forward pointers
SQLFull Outer JOIN old-style vs ANSI Full Outer JOIN Instead of DELETE trg on VIEW
SQLInstead of INSTEAD trg on UNION VIEW JOINs with dummy rows Multiple contraints