Home
Submit
Free Hosting
Link To Us
Contacts
SQL serializable mode
SQL
Download
(.zip)
USE PUBS
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRAN
SELECT * FROM authors
WHERE au_lname = 'Ringer'
EXEC sp_lock2 @@spid
COMMIT TRAN
SQL
Default lock mode
Repeatable read mode
serializable mode
SQL
Update in serializable mode no index
Update in serializable mode with index