Reviewing Programming Structures

Every programming language, including T-SQL, has a set way of performing multiple actions, checking whether an action is needed, or performing the same action multiple times. Because a computer processes commands linearly—that is, in a straight line—and program code or SQL script must be presented in a structured format, you will find the different topics in this section very useful. What you will learn in this section are the basic building blocks for this structured style of programming in T-SQL.

Understanding Batches

A batch is a collection of one or more SQL statements that are sent to the server as one group by a client application, such as Query Analyzer. Each batch is then compiled or translated into a single ...

Get Sams Teach Yourself Transact-SQL in 21 Days, Second 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.