<p>Ceci concerne <a href="http://msdn.microsoft.com/en-us/library/ms131092(SQL.90).aspx">SQL Server 2005</a>. Il existe des versions mises a jour du tableau pour <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.100%29.aspx">SQL Server 2008</a>, <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.105%29.aspx">SQL Server 2008 R2</a>, <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.110%29.aspx">SQL Server 2012</a> et <a href="http://msdn.microsoft.com/en-us/library/ms131092(v=sql.120).aspx">SQL Server 2014</a>.</p>
<p>Types de donnees SQL Server et leurs equivalents .NET Framework</p>
<p>Le tableau suivant liste les types de donnees Microsoft SQL Server, leurs equivalents dans le Common Language Runtime (CLR) pour SQL Server dans l’espace de noms <strong>System.Data.SqlTypes</strong>, et leurs equivalents CLR natifs dans le Microsoft .NET Framework.</p>
<p>SQL Server data type<br>
CLR data type (SQL Server)<br>
CLR data type (.NET Framework)</p>
<p>varbinary<br>
SqlBytes, SqlBinary<br>
Byte<span class="chcklst-box fa fa-square-o"></span></p>
<p>binary<br>
SqlBytes, SqlBinary<br>
Byte<span class="chcklst-box fa fa-square-o"></span></p>
<p>varbinary(1), binary(1)<br>
SqlBytes, SqlBinary<br>
byte, Byte<span class="chcklst-box fa fa-square-o"></span></p>
<p>image<br>
None<br>
None</p>
<p>varchar<br>
None<br>
None</p>
<p>char<br>
None<br>
None</p>
<p>nvarchar(1), nchar(1)<br>
SqlChars, SqlString<br>
Char, String, Char<span class="chcklst-box fa fa-square-o"></span></p>
<p>nvarchar<br>
SqlChars, SqlString<br>
String, Char<span class="chcklst-box fa fa-square-o"></span></p>
<p>nchar<br>
SqlChars, SqlString<br>
String, Char<span class="chcklst-box fa fa-square-o"></span></p>
<p>text<br>
None<br>
None</p>
<p>ntext<br>
None<br>
None</p>
<p>uniqueidentifier<br>
SqlGuid<br>
Guid</p>
<p>rowversion<br>
None<br>
Byte<span class="chcklst-box fa fa-square-o"></span></p>
<p>bit<br>
SqlBoolean<br>
Boolean</p>
<p>tinyint<br>
SqlByte<br>
Byte</p>
<p>smallint<br>
SqlInt16<br>
Int16</p>
<p>int<br>
SqlInt32<br>
Int32</p>
<p>bigint<br>
SqlInt64<br>
Int64</p>
<p>smallmoney<br>
SqlMoney<br>
Decimal</p>
<p>money<br>
SqlMoney<br>
Decimal</p>
<p>numeric<br>
SqlDecimal<br>
Decimal</p>
<p>decimal<br>
SqlDecimal<br>
Decimal</p>
<p>real<br>
SqlSingle<br>
Single</p>
<p>float<br>
SqlDouble<br>
Double</p>
<p>smalldatetime<br>
SqlDateTime<br>
DateTime</p>
<p>datetime<br>
SqlDateTime<br>
DateTime</p>
<p>sql_variant<br>
None<br>
Object</p>
<p>User-defined type(UDT)<br>
None<br>
user-defined type</p>
<p>table<br>
None<br>
None</p>
<p>cursor<br>
None<br>
None</p>
<p>timestamp<br>
None<br>
None</p>
<p>xml<br>
SqlXml<br>
None</p>
