asp如何调用存贮过程(50分)

在示列数据库PUBS上建立存贮过程:
CREATE PROCEDURE aaa
@abc char(10),
@mycount int output
AS
select @mycount=count( *) from employee where minit=@abc
return
GO

现求用ASP代码写调用这个过程,救助!

通过ODBC,我在DM那自动生成如下调用代码,请改,如不改用其它代码也可
<%

Dim cmd__aaa
cmd__aaa = ""
if(Request("aaa&quot <> "&quot then cmd__aaa = Request("aaa&quot

%>
<%

set cmd = Server.CreateObject("ADODB.Command&quot
cmd.ActiveConnection = MM_abc_STRING
cmd.CommandText = "dbo.abc"
cmd.CommandType = 4
cmd.CommandTimeout = 0
cmd.Prepared = true
cmd.Parameters.Append cmd.CreateParameter("@RETURN_VALUE", 3, 4)
cmd.Parameters.Append cmd.CreateParameter("@aaa", 129, 1,4,cmd__aaa)
cmd.Parameters.Append cmd.CreateParameter("@mycount", 3, 2)
cmd.Execute()

%>

cmd.CommandText = "dbo.abc" 这句错了应该是: cmd.CommandText = "dbo.aaa"
cmd.Parameters.Append cmd.CreateParameter("@aaa", 129, 1,4,cmd__aaa) 应该改为cmd.Parameters.Append cmd.CreateParameter("@abc", 129, 1,4,cmd__aaa)