If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link [ Ссылка ] to make a donation. Thanks for watching!

By Andrew Gould

[ Ссылка ] - Transactions take place whenever you modify data in your database. Normally this process is handled by SQL Server but this video teaches you how to control your transactions. You'll learn how to specify when your transactions begin, when the changes are committed and even how to undo the changes using the Rollback statement. We'll also cover how to use transactions with error handling code, how to create savepoints within a transaction, and how to use nested transactions in stored procedures.

You can download the script to create the Movies database used in this video at the following link:
[ Ссылка ]

You can see the range of resources and courses we offer in SQL Server here:
[ Ссылка ]

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

свернуть