Use transactions SQL Server


show more Using transactions provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Using transactions

Database developers can and should use transactions, to provide a logical grouping of actions. Transactions can happen inside of a stored procedure or outside of the stored procedure. I typically do most of my transactions inside of stored procedures. And we'll talk a few reasons about why. I have on the screen some code you can get from the exercise files. It's a basic stored procedure, that's going to either delete or deactivate an author. There's one UPDATE statement that runs on line 6, 7 and 8. That's going to set the particular author's active status to 0, meaning he is inactive.

And then lines 10, 11 and 12, set his phone number equal to Null. So this is a hypothetical where we want to stop tracking personal information about people that are no longer active. Lines 14 to 17, allow us to potentially roll- back the transaction if there's a problem. So this will help us avoid the situation, where we might end up with an author who we couldn't mark as inac...

Using transactions
Video duration: 2m 47s 1h 52m Advanced

Viewers:

Using transactions provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...