O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Implementing Transactions, Error Handling, and Dynamic SQL

Exam objectives in this chapter:

  • Work with Data

    • Query data by using SELECT statements.

  • Troubleshoot & Optimize

    • Optimize queries.

    • Manage transactions.

    • Implement error handling.

Microsoft SQL Server is a relational database that strictly enforces transactional behavior on database changes in order to protect data integrity. This chapter presents the T-SQL code behind transactions, and extends that code to handling errors and using dynamic SQL.

Lessons in this chapter:

Before You Begin

To complete the lessons in this chapter, you must have:

  • An understanding of basic database concepts. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required