Advertisement

Stored Procedures

  • Russell Sinclair

Abstract

As described in previous chapters, stored procedures are sets of instructions for SQL Server that are compiled into a single plan. Stored procedures are a new concept to most Access programmers because there is no equivalent in Access. For this reason, stored procedures are often misused or implemented poorly. Also, Access developers tend not to use stored procedures to their full potential or as much as stored procedures should be used in SQL Server. Stored Procedures can be very powerful and can be used to replace much of the VBA code and macros that most programmers use in an Access application. Because they are so important in SQL Server, I will provide you with information on how to create them, how to use them effectively, and how to determine what portions of an Access application can be migrated to stored procedures.

Keywords

Error Handling Temporary Table Case Expression Store Procedure Access Application 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Russell Sinclair 2000

Authors and Affiliations

  • Russell Sinclair

There are no affiliations available

Personalised recommendations