Microsoft® SQL Server™ 2000 Unleashed, Second Edition

Chapter 28. Creating and Managing Stored Procedures in SQL Server

by Ray Rankins

IN THIS CHAPTER

• Advantages of Stored Procedures

• Creating and Executing Stored Procedures

• Deferred Name Resolution

• Viewing and Modifying Stored Procedures

• Using Input Parameters

• Using Output Parameters

• Returning Procedure Status

• Cursors in Stored Procedures

• Nested Stored Procedures

• Using Temporary Tables in Stored Procedures

• Using the table Datatype

• Remote Stored Procedures

• Debugging Stored Procedures with Query Analyzer

• Debugging with Microsoft Visual Studio and Visual Basic

• System Stored Procedures

• Stored-Procedure Performance

• Using Dynamic SQL in Stored Procedures

• Autostart Procedures

• Extended Stored Procedures

• Stored Procedure Coding Guidelines and Limitations

A stored procedure ...