SQL Isolation Levels EX 3 Connection 1

Isolation Levels EX 3 Connection 1

-- Batch 1
USE PUBS
GO

-- Batch 4
INSERT titles VALUES 
    ('BU2000', 'Inside SQL Server 2000', 
     'popular_comp', '0877', 59.95, 5000, 
      10, 0, null, 'Sep 10, 2000')
GO(


-- Batch 6
INSERT titles VALUES 
    ('BU3000', 'Itzik and His Black Belt SQL Tricks',  
     'popular_comp', '0877', 39.95,  10000, 12, 15000, 
      null, 'Sep 15 2000')
GO
--(query will block)

-- Batch 8 
-- not really a separate batch, 
-- but a separate step
-- Now notice that query -- has completed