Chapter 5

Procedural Programming

In this chapter, we'll explore Transact-SQL as a procedural programming language and develop an understanding of procedural objects. Understanding the procedural structures available to you in Transact-SQL is an essential step in the process of creating stored procedures and user-defined functions.

SQL Server provides many procedural programming possibilities. We will first explore the statements that make up the different procedural structures. You will learn about conditional logic, control-of-flow, error handling, and more. You will also learn the syntax for the different procedural structures, as well as the reasoning behind the usage of objects in SQL Server. Get ready to program using Transact-SQL.

In this ...

Get Mastering SQL Server® 2008 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.