Transactions are great, but sometimes you need something more than total success or total failure. This course will teach you how to implement error handling to create sophisticated error handling flows.

What you'll learn

Transactions help you manage the state of an operation, but don't provide for complex flows beyond mere success or failure. In this course, Integrate Transactions and Error Handling in SQL Server, you'll gain the ability to implement error handling to create sophisticated error handling flows. First, you'll explore error handling for batch imports. Next, you'll discover how to use error handling to support a complex update. Finally, you'll learn how to manage schema updates in a way that allows reversion or continuing the process. When you're finished with this course, you'll have the skills and knowledge of integrating error handling and transactions needed to structure your SQL workflows in a robust and recoverable way.