Stored Procedures

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.