Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Control-of-Flow Language

Before getting into some of the finer points of stored procedures (such as using parameters or returning values), it is important to cover a very important topic: control-of-flow language. Control-of-flow language gives your stored procedures added capabilities not found in standard Transact-SQL. Using control-of-flow language, you can make use of standard programming techniques such as performing loops or conditional processing on variables.

TIP

Want to learn how to write good stored procedures? The first requirement is to learn SQL and the many additional Transact-SQL features. The next step is to become familiar with the different control-of-flow statements and their uses. Learn these fundamentals, and you are on your ...