How to call a stored procedure

How to call stored procedures is a problem for beginners. asp calls stored procedures and SQL calls stored procedures. I don't think this is a problem for beginners. Let's take a look at this problem. & Nbsp; ASP calls several methods with parameter stored procedures. 1) this is also the simplest method. Two input parameters have no return value, there are many Insert, Update, and Delete operations. Reference content: & nbsp; & nb How to call a stored procedureThis is a problem for beginners. asp calls the stored procedure and SQL call Stored ProcedureI don't think this is a problem for beginners. Let's take a look at this problem.

Several Methods for ASP to call stored procedures with Parameters

1) this is also the simplest method. Two input parameters have no return values and are used for Insert, Update, and Delete operations.

Reference content is as follows:
Conn. Execute "procname varvalue1, varvalue2"

2) If you want to return the Recordset:

Reference content is as follows:
Set rs = server. createobject ("adodb. recordset ")
Rs. Open "Exec procname varvalue1, varvalue2", conn
Webjx. Com

3) Neither of the preceding methods can return values (except for Recordset). To obtain the return value, use the Command method.

First, there are two return values. One is to directly return a value in the stored procedure, just like the return values of C and VB functions; the other is to return multiple values, the variable name that stores these values must be specified in the call parameters first.