Advertisement

Stored Procedures

  • Brian Driscoll
  • Nitin Gupta
  • Rob Vettor
  • Zeeshan Hirani
  • Larry Tenny
Chapter

Abstract

Stored procedures are fixtures in the life of just about anyone who uses modern relational database systems such as Microsoft’s SQL Server. A stored procedure is a bit of code that lives on the database server and often acts as an abstraction layer isolating the code consuming the data from many of the details of the physical organization of the data. Stored procedures can increase performance by moving data-intensive computations closer to the data, and they can act as a data-side repository for business and security logic. The bottom line is that if you use data, you will consume it at some point through a stored procedure.

Keywords

Sales Manager Design Surface Custom Function Return Type Entity Collection 
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.

Copyright information

© Brian Driscoll 2013

Authors and Affiliations

  • Brian Driscoll
    • 1
  • Nitin Gupta
    • 1
  • Rob Vettor
    • 1
  • Zeeshan Hirani
    • 1
  • Larry Tenny
    • 1
  1. 1.COUS

Personalised recommendations