O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required