Chapter 15 -- Using Stored Procedures

Chapter 15

In Chapter 12, we saw that within Microsoft Visual InterDev 6.0 you have access to the Microsoft Visual Database Tools for creating and managing your data-driven applications. When working with more advanced databases such as Microsoft SQL Server or Oracle, as opposed to Access and other desktop-style databases, you can take advantage of Visual InterDev's support for the creation, editing, debugging, and execution of stored procedures.

In this chapter, we'll take a look at stored procedures in detail. We'll start by looking at the benefits of stored procedures over other techniques, and then we'll go into detail on how to incorporate stored procedures into your Visual InterDev 6.0 applications. We'll look at all aspects of stored procedure development from the initial creation of the database and the various stored proce-dures, through editing and debugging, and finally to execution of stored procedures both within the run-time environment and in the deployment environment. The database we'll use for our example will be SQL Server 6.5, but these examples could easily apply to SQL Server 7.0 or Oracle 7.x or later with a few minor syntax changes where necessary.