-- Batch 2
USE PUBS
GO
-- Batch 3
-- First verify there's only
-- one author named 'Smith'
SELECT au_lname FROM authors
WHERE au_lname='Smith'
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
-- Batch 5
SELECT au_lname FROM authors
WHERE au_lname='Smith'
GO
IF (@@ROWCOUNT > 1)
PRINT 'Just read uncommitted data !!'
GO
-- Batch 7
-- Now check again for authors -
-- of name 'Smith'.
-- Find only one now, because other
-- connection did a rollback.
SELECT au_lname FROM authors
WHERE au_lname='Smith'
GO
