USE AdventureWorks
 --This Transaction will be run on another connection

BEGIN TRAN
  UPDATE NewEmployee WITH (PAGLOCK)
  SET Title = 'Benefits Specialist'
  WHERE FirstName = 'Richard' AND LastName = 'Runyan'

  UPDATE NewEmployee WITH (PAGLOCK)
  SET Title = 'Tool Designer'
  WHERE FirstName = 'Brenda' AND LastName = 'Marshall'


COMMIT TRAN


exec sp_lock
select @@spid

select * from newemployee