command.execute 存储过程应用

来源：百度知道 编辑：UC知道 时间：2024/06/21 23:23:03
求一个command.execute 调用存储过程实例,要一个带参数的,和一个不带参数的,以及对返回值的引用.返回类型最好多样化.在线等,有在线知道的更好!可以加分.
VC语法的,高手帮帮忙啊.把例子发我也可以!
帮帮忙啊!!高分下面无勇夫啊!唉!

定义存储过程
CREATE PROCEDURE sp_CountUsers AS
Return (select count (*) from users)
______________________________________________________________________
asp页面

<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>

<%
Dim conn,cmd,param
Set conn = server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Driver={SQL Server};Server=.;Database=UserDB"
conn.Open
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "sp_CountUsers"
cmd.CommandType = adCmdStoredProc ’错误提示为此行
Set param = cmd.CreateParameter("ReCount",adInteger,adParamReturnValue)
cmd.Parameters.Append param
cmd.Execute
Response.write "用户表中的总纪录数为:" & cmd.Parameters("ReCount")
Set cmd = Nothing
conn.Close
Set conn = Nothing