Application #13. Use Stored Procedures
This sample shows you how to programmatically create stored procedures and then use them to retrieve data from SQL Server (or MSDE). The use of Microsoft Access queries is also demonstrated. A variety of stored procedures will be used. One requires an input parameter, another does not; and a third stored procedure makes use of input parameters, output parameters, and a return value. Figure 3-2 shows a screen shot of Application #13.
Figure 3-2. Application #13.
The sample application is divided into a series of tabbed demonstrations that each build on the other as you proceed from left to right. In the ...