Chapter 10. Programmable Objects

In this chapter:
Section 10.1
Section 10.2
Section 10.3
Section 10.4
Section 10.5
Section 10.6
Section 10.7
Section 10.8
Section 10.9

This chapter provides a brief overview of programmable objects to familiarize you with the capabilities of Microsoft SQL Server in this area and with the concepts involved. The chapter covers variables; batches; flow elements; cursors; temporary tables; dynamic SQL; routines such as user-defined functions, stored procedures, and triggers; and dynamic SQL. The purpose of this chapter is to provide a high-level overview, not to delve into technical details. Try to focus on the logical aspects and capabilities of programmable objects rather than trying to understand all code elements and their technicalities. For details and more in-depth coverage of programmable objects, please refer to the book Inside Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press, 2009).