Chapter 12
Programmable objects
This chapter provides a brief overview of programmable objects to familiarize you with the capabilities of T-SQL 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 error handling.
This chapter is designed, in part, to be used as a reference for describing programmability-related language elements that are mentioned earlier in the book. To be consistent with the book’s focus, which is T-SQL fundamentals, and the goal to make this book accessible, this chapter was not designed to be an exhaustive guide for T-SQL programmability. Some important programmability ...
Get T-SQL Fundamentals, 4th Edition 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.
