hinne 5 – https://www.youtube.com/watch?v=shkt9Z5Gz-U

updating table and setting qtyavailable to 200 where id is 1

begining transaction and updating qtyavailable to 300 where productid is 1

setting isolation level

rollbacking the transaction. qtyavailable was 300 after rollback it’s 200

commiting transaction and showing two tables

creating procedure that will update data and then rollbacking

altering the procedure and then rollbacking

пример со следующей страницы https://proselyte.net/tutorials/sql/sql-transactions/