Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Chapter 16. Understanding Cursors, Sets, and Temporary Tables

Exam objectives in this chapter:

• Troubleshoot & Optimize

  • Evaluate the use of row-based operations vs. set-based operations.

This chapter covers two main topics. It starts with a lesson about the differences between row-by-row operations and set-based operations. It then continues with a lesson about the use of temporary objects like local temporary tables and table variables, explaining when you should consider using each kind.

Lessons in this chapter:

• Lesson 1: Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions

• Lesson 2: Using Temporary Tables vs. Table Variables

Before You Begin

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

• Experience working with Microsoft ...