事务1.sql

来自「本代码简单明了」· SQL 代码 · 共 16 行

--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