How to execute the stored procedure in ASP?

Source: Internet
Author: User
1. What is a stored procedure?
A stored procedure is a program written in the Tranact-SQL language provided by SQL server.
2. How to create a stored procedure?
Create Procedure EmployeeID_Orders
@ EmployeeID as int
As
Select * from orders
Where employeeID = @ EmployeeID
3. Execute the stored procedure in ASP:
A. Write an SQL statement: "execute stored procedure name is too large, and then run it through connection.exe cute or recordset. open.
StrSql = "execute employeeID_Orders 1"
Set objRstOrders = objCnnNorthwind. Execute (strSql)
B. Commands whose execution type is acw.storedproc through the command object
'Create Command object
Set obj1_northwind = Server. CreateObject ("ADODB. Command ")
'Set the command text
Obj1_northwind. CommandText = "EmployeeID_Orders"
'Set the command type
Obj1_northwind. CommandType = ad1_storedproc
'Set the connection object used by the command object
Set obj1_northwind. ActiveConnection = objCnnNorthwind

'Create a parameter object
Set objParam = obj1_northwind. CreateParameter ("@ EmployeeID", adInteger, adParamInput)
'Add the parameter object to the parameter set of the command object
Obj1_northwind. Parameters. Append objParam
'Set the parameter value
ObjParam. Value = 2

'Command execution object
Set objRstOrders = obj1_northwind. Execute ()
'Destroy command object
Set obj1_northwind = Nothing

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.