1
Posted on 3:32 AM by Softminer and filed under

BEGIN TRANSACTION;
update Table1
set column1 = 'value1'
where key = 1

update Table2
set column2 = 'value2'
where key = 2


--COMMIT

--ROLLBACK

-- First run with "BEGIN TRANSACTION"
-- If it was OK then run "COMMIT"
-- If it was not OK then run "ROLLBACK"

1
Response to ... BEGIN - ROLLBACK - COMMIT TRANSACTION
Divya D said... May 3, 2018 at 2:09 AM

Informative blog .. Thnq you for sharing..

Selenium training | Selenium training in chennai