VC6.0中调用带有返回值的存储过程问题

[whj1001]

在VC++ 6.0中调用带有返回值的存储过程怎么调用？请高手多多指教

我知道怎么调用没有返回值的存储过程，对于有返回值的存储过程，不知道怎么调用，请大家多多帮忙，谢谢了

存储过程的代码如下：
CREATE PROCEDURE Book_Borrow @in_ReaderID char(8), @in_ISBN char(18), @in_BookID char(10)
AS
BEGIN
IF NOT EXISTS(SELECT * FROM TReader WHERE ReaderID=@in_ReaderID)
RETURN 1
IF NOT EXISTS(SELECT * FROM TBook WHERE ISBN=@in_ISBN)
RETURN 2
IF (SELECT Num FROM TReader WHERE ReaderID=@in_ReaderID)=5
RETURN 3
IF (SELECT SNum FROM TBook WHERE ISBN=@in_ISBN)=0
RETURN 4
IF @in_ISBN IN (SELECT ISBN FROM TLend WHERE ReaderID=@in_ReaderID)
RETURN 5
IF EXISTS(SELECT * FROM TLend WHERE BookID=@in_BookID)
RETURN 6
BEGIN TRAN /*开始一个事务*/
INSERT INTO TLend VALUES(@in_BookID, @in_ReaderID, @in_ISBN, GETDATE())
IF @@ERROR>0 /*如果前面一条SQL语句出错则回滚事务并返回6*/
BEGIN
ROLLBACK TRAN
RETURN 7
END
UPDATE TReader SET Num=Num+1 WHERE ReaderID=@in_ReaderID
IF @@ERROR>0 /*如果前面一条SQL语句出错则回滚事务并返回6*/
BEGIN
ROLLBACK TRAN
RETURN 7
END
UPDATE TBook SET SNum=SNum-1 WHERE ISBN=@in_ISBN
IF @@ERROR=0 /*如果所有语句都不出错则结束事务并返回0*/
BEGIN
COMMIT TRAN
RETURN 0
END
ELSE /*如果执行出错则回滚所有操作并返回6*/
BEGIN
ROLLBACK TRAN
RETURN 7
END
END

如果没有返回值，代码是这样的：
CString SqlStr;
SqlStr.Format("Book_Borrow");
pCmd->CommandText = (_bstr_t)SqlStr;
pCmd->CommandType = adCmdStoredProc;

pParam = pCmd->CreateParameter("@in_ReaderID",adVarChar,adParamInput,8);
pParam->Value = _variant_t(m_ReaJSZH);
pCmd->Parameters->Append(pParam);

pParam = pCmd->CreateParameter("@in_ISBN",adVarChar,adParamInput,18);
pParam->Value = _variant_t(m_TsISBN); //ISBN参数值
pCmd->Parameters->Append(pParam);

pParam = pCmd->CreateParameter("@in_BookID",adVarChar,adParamInput,10);
pParam->Value = _variant_t(m_TsID);
pCmd->Parameters->Append(pParam);

// 执行存储过程，结果记录集保存到pRs中
pRs = pCmd->Execute(&vNULL,&vNULL,adCmdStoredProc);

[Allen_zhang]

这种我一般采用输出参数