Introduction to Stored Procedures
By working with the Query Analyzer in Chapter 5 we saw how to use the basic SELECT, INSERT, UPDATE, and DELETE statements in the queries that we wrote. While writing queries in the Query Analyzer is great for ad hoc queries and reporting, they cannot be accessed from our VB programs and distributed to the users of our applications. This is where stored procedures come in; we can access them from our VB programs, and they are available to all users of our applications.
KeywordsError Handling Query Window Software Form Store Procedure Parameter Collection
Unable to display preview. Download preview PDF.