ADODB.Command访问存储过程如何得到返回值

[mongmong]

SQL Server里有如下的存储过程

CREATE PROCEDURE [dbo].[Hello]
AS
select * from member

return 10
GO

现在使用ADO的ADODB.Command对象访问该存储过程，但是不知如何得到该过程的返回值（此处为10），那位大虾知道如何取得该值

[mongmong]

送分了

[bill81]

delcae @str int
select * from member
exec @str output

[crystal_heart]

不知道，一般我是用OUT把返回值放到参数里边。

[hycao]

Dim Sc As String, Result As String
Dim Cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Sc = "Driver={SQL Server}; Server=(local);Uid=sa;pwd=;database=Access_temp"
Cn.Open Sc
Set cmd.ActiveConnection = Cn
With cmd
.CommandType = adCmdStoredProc
.CommandText = "Hello"
End With
cmd(0).Direction = adParamReturnValue
cmd.Execute
Result = cmd(0)
MsgBox Result
Set Cn = Nothing