• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Designing SQL Server Stored P... > Why This Chapter Is Important

Why This Chapter Is Important

Stored procedures are at the heart of any client/server application. This is because, using stored procedures, you can guarantee that processing is completed on the server. Stored procedures have many other benefits as well:

  • Stored procedures help you to separate the client application from the structure of the database.

  • Stored procedures help you to simplify client coding.

  • Stored procedures process at the server (reducing required bandwidth).

  • Stored procedures allow you to create reusable code.

  • Stored procedures allow you to perform error handling at the server.

  • Stored procedures facilitate the security of data.

  • Because stored procedures are precompiled, they execute more quickly.

  • Stored procedures improve the stability of the application.

  • Stored procedures reduce network locking.

  • When you build a stored procedure, a query plan is created. This query plan contains the most efficient method of executing the stored procedure given available indexes and so on.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint