Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to call SQL Server stored procedures from ASP
Article ID: 164485 - View products that this article applies to.
This article was previously published under Q164485
For a Microsoft Visual Basic .NET version of this article, see 306574This article demonstrates three methods of calling a stored procedure from Active Server Pages using ActiveX Data Objects (ADO).
The following example uses the Command object to call a sample stored procedure sp_test. This stored procedure accepts an integer and has a return value of an integer as well:
Note in the above examples, various methods of accessing the Parameters collection of the Command object are used. Some use the default collection of the Command object while others specify what property of a given collection to access.
For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:
Article ID: 164485 - Last Review: May 2, 2006 - Revision: 4.0