O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

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

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