a4-3.cfm.htm

教你在ASP中使用SQL Server的好教材

    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBinary</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">128</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">二进制值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBoolean</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">11</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">布尔值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adBSTR</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">8</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">Null-中断字符串(Unicode)</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adChar</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">129</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">字符串值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adCurrency</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">6</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">货币值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDate</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">7</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBDate</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">133</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期值（yyyymmdd）</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBTime</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">134</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">时间值(hhmmss)</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDBTimeStamp</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">135</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">日期时间值（yyyymmddhhmmss）</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDecimal</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">14</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">具有固定的精度和范围的扩展数字型。</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adDouble</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">5</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">双精度浮点数值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adEmpty</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">0</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">空值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adError</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">10</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">32位错误码</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adGUID</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">72</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">全球唯一的标志码</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adIDispatch</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">9</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">指向一个OLE对象Idispatch的指针</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adInteger</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">3</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adIUnknown</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">13</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">指向一个OLE对象Iunkown的指针</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adNumeric</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">131</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">具有固定的精度和范围的扩展数字型。</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adSingle</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">单精度浮点值</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adSmallInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adTinyInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">16</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">1字节有符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedBigInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">21</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">8字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">19</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">4字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedSmallInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">18</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">2字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUnsignedTinyInt</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">17</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">1字节无符号整数</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adUserDefined</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">132</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">未定义变量</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adVariant</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">12</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">OLE自动变量</font></td>
  </tr>
  <tr>
    <td WIDTH="31%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">adWchar</font></td>
    <td WIDTH="10%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">130</font></td>
    <td WIDTH="58%" VALIGN="TOP"><font FACE="宋体" LANG="ZH-CN" SIZE="3"><p ALIGN="JUSTIFY">NULL-中断Unicode字符串</font></td>
  </tr>
</table>
</center></div><font FACE="宋体" LANG="ZH-CN"><b>

<p ALIGN="JUSTIFY">UnderlyingValue</p>
</b></font><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">从数据库中返回该域的当前值。</p>
</font><font FACE="宋体" LANG="ZH-CN"><b>

<p ALIGN="JUSTIFY">Value</p>
</b></font><font FACE="宋体" LANG="ZH-CN" SIZE="3">

<p ALIGN="JUSTIFY">域的值</p>
</font>
</body>
</html>