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.
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 ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.