StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This is for <a href="http://msdn.microsoft.com/en-us/library/ms131092(SQL.90).aspx" rel="noreferrer">SQL Server 2005</a>. There are updated versions of the table for <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.100%29.aspx" rel="noreferrer">SQL Server 2008</a>, <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.105%29.aspx" rel="noreferrer">SQL Server 2008 R2</a>, <a href="http://msdn.microsoft.com/en-us/library/ms131092%28v=sql.110%29.aspx" rel="noreferrer">SQL Server 2012</a> and <a href="http://msdn.microsoft.com/en-us/library/ms131092(v=sql.120).aspx" rel="noreferrer">SQL Server 2014</a>.</p> <h2>SQL Server Data Types and Their .NET Framework Equivalents</h2> <p>The following table lists Microsoft SQL Server data types, their equivalents in the common language runtime (CLR) for SQL Server in the <strong>System.Data.SqlTypes</strong> namespace, and their native CLR equivalents in the Microsoft .NET Framework.</p> <pre><code>SQL Server data type CLR data type (SQL Server) CLR data type (.NET Framework) varbinary SqlBytes, SqlBinary Byte[] binary SqlBytes, SqlBinary Byte[] varbinary(1), binary(1) SqlBytes, SqlBinary byte, Byte[] image None None varchar None None char None None nvarchar(1), nchar(1) SqlChars, SqlString Char, String, Char[] nvarchar SqlChars, SqlString String, Char[] nchar SqlChars, SqlString String, Char[] text None None ntext None None uniqueidentifier SqlGuid Guid rowversion None Byte[] bit SqlBoolean Boolean tinyint SqlByte Byte smallint SqlInt16 Int16 int SqlInt32 Int32 bigint SqlInt64 Int64 smallmoney SqlMoney Decimal money SqlMoney Decimal numeric SqlDecimal Decimal decimal SqlDecimal Decimal real SqlSingle Single float SqlDouble Double smalldatetime SqlDateTime DateTime datetime SqlDateTime DateTime sql_variant None Object User-defined type(UDT) None user-defined type table None None cursor None None timestamp None None xml SqlXml None </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload