How to implement Transactions (COMMIT / ROLLBACK) using SQL SERVER.

Published: 28 July 2021
on channel: Software Nuggets

10,776

182

In this video, I will introduce transactions in SQL server. We will learn about how to recover your data using the ROLLBACK command, how to save your changes permanently to the database using the transaction COMMIT command.

We will look at how BEGIN TRANSACTION affects other users, and how SQL Server has given us some tools to work around these obstacles.

Show example of the Dirty Read situation.

TIMELINE
00:00 Begin Video
00:10 Preview
00:41 Behind the scenes
01:00 Let's make an error without using transaction management
01:35 - Intro to Begin Tran
04:53 - How affects other users
06:47 - Dirty Read
08:53 - NOLOCK

-- by : software nuggets
-- is a : sql server nugget
#softwareNuggets, #sqlServer, #beginTransactions, @softwareNuggets

On this page of the site you can watch the video online How to implement Transactions (COMMIT / ROLLBACK) using SQL SERVER. with a duration of hours minute second in good quality, which was uploaded by the user Software Nuggets 28 July 2021, share the link with friends and acquaintances, this video has already been watched 10,776 times on youtube and it was liked by 182 viewers. Enjoy your viewing!

1,180