Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2003 Thearon Willis
About this chapter
Cite this chapter
Willis, T. (2003). Introduction to Stored Procedures. In: Beginning SQL Server 2000 for Visual Basic Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5131-6_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5131-6_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-273-1
Online ISBN: 978-1-4302-5131-6
eBook Packages: Springer Book Archive