vc++中，用ado执行sql server存储过程，并且取得返回值的例子

_variant_t RecordsAffected;

string szSql = (string)"P_KS_ADDUSER '" + m_szName+ "','" + m_szPasswd +"';";

try

{

_CommandPtr ptrCmd;

ptrCmd.CreateInstance(__uuidof(Command));

ptrCmd->ActiveConnection = pContext->GetConnection();

VARIANT vtRoyalty;

vtRoyalty = COleVariant((long)0);

ptrCmd->Parameters->Append(

ptrCmd->CreateParameter("Return", adInteger, adParamReturnValue,sizeof(int),vtRoyalty));

vtRoyalty = COleVariant(m_szName.c_str());

ptrCmd->Parameters->Append(

ptrCmd->CreateParameter("Name", adChar, adParamInput,m_szName.size(),vtRoyalty));

vtRoyalty = COleVariant(m_szPasswd.c_str());

ptrCmd->Parameters->Append(

ptrCmd->CreateParameter("Pass", adChar, adParamInput,m_szPasswd.size(),vtRoyalty));

ptrCmd->CommandText = "P_KS_ADDUSER";

ptrCmd->CommandType = adCmdStoredProc;

ptrCmd->Execute(NULL,NULL,adCmdStoredProc);

cout<<"添加用户成功，id="<<(unsigned int)ptrCmd->Parameters->GetItem("Return")->GetValue()<<endl;

//cout<<"add id:"<<(unsigned int)ptrCmd->GetParameters()->GetItem(0)<<endl;

//pContext->GetNetworkSender()->SendPack();

}

catch(_com_error e)

{

cout<<"增加用户的时候发生异常:"<<(LPCSTR)e.Description()<<endl;

return;

}

要是有多个值要返回，那么可以使用输出参数(output parameter)的方法；要是需要返回一个数组，可以使用返回数据集的方法。