SQL Isolation Levels EX 1 Connection 1
Isolation Levels EX 1 Connection 1
-- Batch 1
USE PUBS
GO
-- Batch 4
BEGIN TRAN
UPDATE authors
SET au_lname='Smith'
-- Give other connection chance to
-- read uncommitted data
GO
-- Batch 6
-- UNDO the changes
-- to the authors table
ROLLBACK TRAN
GO