One of ADO's strong points is its capability to execute SQL Server stored procedures. Using ADO, you can easily pass input parameters to stored procedures and retrieve the values of output parameters. The sections that follow cover the ins and outs of executing stored procedures and responding to the information that they output.
The code examples that follow require you to create the associated stored procedures in the NorthWind database prior to running the code.
The easiest way to execute a stored procedure is to use the Command object. Listing 10.13 provides an example.
Private Sub cmdNoParms_Click() Dim com As ...