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. ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.