SQL Isolation Levels EX 2 Connection 1
Isolation Levels EX 2 Connection 1
-- Batch 1
USE PUBS
GO
-- Batch 4
UPDATE authors
SET au_lname='Smith'
GO
-- Batch 6
UPDATE authors
SET au_lname='Jones'
GO
--(query will block)
-- Batch 8, not really a separate batch,
-- but a separate step
-- Now notice that query
-- has completed