ASP中如何执行存储过程？

 

     通command对象执行类型为acCmdStoredProc的命令

‘建立Command对象

Set objCmdNorthwind=Server.CreateObject("ADODB.Command")

‘设定命令的文本

objCmdNorthwind.CommandText="EmployeeID_Orders"

‘设定命令的类型

objCmdNorthwind.CommandType=adCmdStoredProc

‘设定命令对象使用的连接对象

Set objCmdNorthwind.ActiveConnection=objCnnNorthwind

 

‘建立参数对象

Set objParam=objCmdNorthwind.CreateParameter("@EmployeeID",adInteger,adParamInput)

‘把参数对象添加到命令对象的参数集中

objCmdNorthwind.Parameters.Append objParam

‘设定参数的值

objParam.Value=2

 

‘执行命令对象

Set objRstOrders=objCmdNorthwind.Execute()

‘销毁命令对象

Set objCmdNorthwind=Nothing