Integrate Transactions and Error Handling in SQL Server
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.
Table of contents
About the author
Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face. He focuses on his flavor of Fear Based Development, whereby a developer ranks their tasks in descending order of anxiety, and how to tackle them in that order. Chief among these anxiety-inducing processes is software deployment, a topic that Behrens focuses upon. He ... more