SQL Server 数据类型映射 (ADO.NET)

「爱情、让人受尽委屈。」 2022-08-08 06:48 4阅读 0赞

原文：[https://msdn.microsoft.com/zh-cn/library/cc716729.aspx][https_msdn.microsoft.com_zh-cn_library_cc716729.aspx]

SQL Server 和 .NET Framework 基于不同的类型系统。 例如，.NET Framework [Decimal][] 结构的最大小数位数为 28，而 SQL Server 的 decimal 和 numeric 数据类型的最大小数位数为 38。 为了在读取和写入数据时维护数据的完整性，[SqlDataReader][] 将公开用于返回 [System.Data.SqlTypes][] 的对象的 SQL Server 特定的类型化访问器方法以及用于返回 .NET Framework 类型的访问器方法。 SQL Server 类型和 .NET Framework 类型也可通过 [DbType][] 和 [SqlDbType][] 类中的枚举表示，当您指定 [SqlParameter][] 数据类型时可以使用这些枚举。

下表显示推断的 .NET Framework 类型、[DbType][] 和 [SqlDbType][] 枚举以及 [SqlDataReader][] 的访问器方法。

<table style="border-collapse:collapse; margin-bottom:20px; margin-top:20px; padding:0px; width:918px; border:1px solid rgb(187,187,187)"> 
 <tbody> 
 <tr> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> SQL Server 数据库引擎类型 </th> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> .NET Framework 类型 </th> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> SqlDbType 枚举 </th> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> SqlDataReader SqlTypes 类型化访问器 </th> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> DbType 枚举 </th> 
 <th style="padding:10px 8px; color:rgb(99,99,99); border:1px solid rgb(187,187,187); font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; background-color:rgb(237,237,237)"> SqlDataReader DbType 类型化访问器 </th> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> bigint </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Int64 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">BigInt</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlint64%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlInt64</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Int64</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getint64%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetInt64</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> binary </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">VarBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbinary%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> bit </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Boolean </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Bit</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlboolean%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBoolean</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Boolean</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getboolean%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBoolean</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> char </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Char</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">AnsiStringFixedLength</a>, <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">String</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> date （仅适用 SQL Server 2008） </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> DateTime </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Date</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Date</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTime</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> datetime </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> DateTime </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTime</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> datetime2 （仅适用 SQL Server 2008） </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> DateTime2 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime2</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime2</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTime</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> datetimeoffset （仅适用 SQL Server 2008） </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> DateTimeOffset </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTimeOffset</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> 无 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTimeOffset</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetimeoffset%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTimeOffset</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> decimal </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Decimal </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDecimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDecimal</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> FILESTREAM 属性 (varbinary(max) </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">VarBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBytes</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> float </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Double </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Float</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldouble%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDouble</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Double</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdouble%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDouble</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> image </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbinary%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> int </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Int32 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Int</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlint32%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlInt32</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Int32</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getint32%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetInt32</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> money </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Decimal </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Money</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlmoney%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlMoney</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDecimal</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> nchar </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">NChar</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">StringFixedLength</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> ntext </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">NText</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">String</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> numeric </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Decimal </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDecimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDecimal</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> nvarchar </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">NVarChar</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">String</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> real </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Single </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Real</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlsingle%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlSingle</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Single</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getfloat%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetFloat</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> rowversion </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Timestamp</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbinary%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> smalldatetime </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> DateTime </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">DateTime</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTime</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> smallint </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Int16 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">SmallInt</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlint16%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlInt16</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Int16</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getint16%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetInt16</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> smallmoney </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Decimal </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">SmallMoney</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqldecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlDecimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Decimal</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdecimal%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDecimal</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> sql_variant </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Object* </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Variant</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlvalue%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlValue</a>&nbsp;* </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Object</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getvalue%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetValue</a>&nbsp;* </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> text </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Text</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">String</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> time （仅适用 SQL Server 2008） </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> TimeSpan </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Time</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> 无 </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Time</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getdatetime%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetDateTime</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> timestamp </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Timestamp</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbinary%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> tinyint </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">TinyInt</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbyte%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlByte</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Byte</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbyte%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetByte</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> uniqueidentifier </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Guid </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">UniqueIdentifier</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlguid%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlGuid</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Guid</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getguid%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetGuid</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> varbinary </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Byte[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">VarBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlbinary%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlBinary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Binary</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getbytes%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetBytes</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> varchar </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> String Char[] </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">VarChar</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlString</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">AnsiString</a>&nbsp;,&nbsp;<a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">String</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getstring%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetString</a> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getchars%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetChars</a> </td> 
 </tr> 
 <tr> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> xml </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> Xml </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Xml</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader.getsqlxml%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">GetSqlXml</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> <a href="https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx" style="text-decoration:none; color:rgb(3,105,122)" rel="nofollow">Xml</a> </td> 
 <td style="font-family:'Microsoft YaHei UI','Microsoft YaHei',SimSun,'Segoe UI','Lucida Grande',Verdana,Arial,Helvetica,sans-serif!important; padding:10px 8px; color:rgb(42,42,42); vertical-align:top; border:1px solid rgb(187,187,187)"> 无 </td> 
 </tr> 
 </tbody> 
</table>

\* 如果已知 sql\_variant 的基础类型，则使用特定的类型化访问器。

[https_msdn.microsoft.com_zh-cn_library_cc716729.aspx]: https://msdn.microsoft.com/zh-cn/library/cc716729.aspx
[Decimal]: https://msdn.microsoft.com/zh-cn/library/system.decimal%28v=vs.100%29.aspx
[SqlDataReader]: https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldatareader%28v=vs.100%29.aspx
[System.Data.SqlTypes]: https://msdn.microsoft.com/zh-cn/library/system.data.sqltypes%28v=vs.100%29.aspx
[DbType]: https://msdn.microsoft.com/zh-cn/library/system.data.dbtype%28v=vs.100%29.aspx
[SqlDbType]: https://msdn.microsoft.com/zh-cn/library/system.data.sqldbtype%28v=vs.100%29.aspx
[SqlParameter]: https://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlparameter%28v=vs.100%29.aspx