Stored Procedures versus SQL Statements

  • Thearon Willis


In the last chapter we talked about stored procedure performance, and explained why stored procedures perform better than in-line SQL statements. This chapter expands on that discussion by using side-by-side comparisons of stored procedures and in-line SQL statements. We will show and demonstrate that stored procedures offer more robust functionality and easier maintenance than in-line SQL statements.


Setup Error Error Handling Store Procedure Parameter Collection Query Analyzer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Thearon Willis 2003

Authors and Affiliations

  • Thearon Willis

There are no affiliations available

Personalised recommendations