存储过程调用时的参数对照

CmdSP.Parameters.Append CmdSP.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 4)
'定义一个字符型输入参数
CmdSP.Parameters.Append CmdSP.CreateParameter("@au_lname", adVarChar, adParaminput, 20, "M")
'定义一个整型输入参数
CmdSP.Parameters.Append CmdSP.CreateParameter("@intID", adInteger, adParamInput, , iVal)
'定义一个整型输出参数
CmdSP.Parameters.Append CmdSP.CreateParameter("@intIDOut", adInteger, adParamOutput, oVal)

参许参数值的类型的意义如下： 
        名称值                           整数值                       功能 
　　addbtimestamp                 135                             日期时间数据类型 
　　addecimal                     14                               十进制整数值 
　　addouble                      5                                 双精度小数值 
　　aderror                       10                               系统错误信息 
        adguid                     72                               全域性唯一识别字(globally   unique   identifier) 
        addispath                  9                                 com/ole自动对象(automation   object) 
        adinteger                  3                                 4字节有符号整数 
        adiunknown                 13                               com/ole对象 
        adlongvarbinary            205                             大型２字节值 
        adlongvarchar              201                             大型字符串值 
        adlongvarwchar             203                             大型未编码字符串 
        adnumeric                  131                             十进制整数值 
        adsingle                   4                                 单精度浮点小数 
        adsmallint                 2                                 2字节有符号整数 
        adtinyint                  16                               1字节有符号整数 
        adunsignedbigint           21                               8字节无符号整数 
        adunsignedint              19                               4字节无符号整数 
        adunsignedsmallint         18                               2字节无符号整数 
        adunsignedtinyint          17                               1字节无符号整数 
        aduserdefined              132                             用户自定义数据类型 
        advariant                  12                               ole对象 
        advarbinary                204                             双字节字符变量值 
        advarchar                  200                             字符变量值 
        advarchar                  202                             未编码字符串变量值 
        adwchar                    130                             未编码字符串                                                 
　　　　 
        方向值的意义如上： 
        名称值                           整数值                       功能 
        adparaminput               1                                 允许数据输入至该参数当中 
        adparamoutput              2                                 允许数据输出至该参数当中 
        adparaminputoutput         3                                 允许数据输入、输出至该参数当中