事务2.sql

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

SQL
16
字号
--Transaction 2
--Step 2
use pubs
begin transaction
update jobs set job_desc = 'SQL' 
where job_id = 2

select * from jobs where job_id = 1
select * from jobs where job_id = 3

commit

rollback 


--

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?