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 is one or more SQL commands stored in a database as an executable object. Stored procedures can be called interactively, from within client application code, from within other stored procedures, and from within triggers. Par-ameters can be passed to and returned from stored procedures to increase their usefulness and flexibility. A stored procedure can also return a number of resultsets and a status code.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net