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; }