--Transaction 1
--Step 1
use pubs
set deadlock_priority low
begin transaction
update jobs set job_desc = 'SQL' 
where job_id = 1



--Step 3

select * from jobs where job_id = 2

commit
rollback