SQL Update in serializable mode no index

SQL

Download (.zip)

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

SQLCreat table nc heap nodupes Creat table nc nodupes Create table clustered nodupes
SQLCursor grant update permission Cursor vs join Decode sysconstraints
SQLDefault lock mode Diff intervals Error checking in proc
SQLError checking in xact Forward pointers Full Outer JOIN old-style vs ANSI
SQLFull Outer JOIN Instead of DELETE trg on VIEW Instead of INSTEAD trg on UNION VIEW