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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.