Rollback transactions to a SavePoint in SQL Server defeats all-or-nothing скачать в хорошем качестве

Rollback transactions to a SavePoint in SQL Server defeats all-or-nothing

In this video, I will show you how to use SavePoints. SavePoints are declared inside of the Begin Transaction and Commit/Rollback. How to use a save point transaction rollback. Normally, you think of a transaction as all-or-nothing, however, using SavePoints, you can change this behavior. You can place a "SavePoint" (bookmark, waypoint, last good position) into the transaction queue, and if necessary, you can rollback to the last "SavePoint" position. Using "SavePoints" defeats the all-or-nothing principal. If you are inserting 100,000 records, and you set a SAVEPOINT after every 10,000 transactions, if an error occurs at 42,283, you can commit 40,000 records to the database. What if each transaction took 2 seconds, can you imagine having to start over every time? @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Hey Team, I would appreciate if you could leave a message for other students to read, a thumbs up if you learned something new and enjoyed the video, and please consider subscribing to this channel. Thank you in advance for your consideration. Let's help each other! @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Here is a link to another video about transactions I created. How to implement Transactions (COMMIT / ROLLBACK) using SQL SERVER.    • How to implement Transactions (COMMIT / RO...   Software Nuggets.