|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="ProgId" content="VisualStudio.HTML">
<meta name="Originator" content="Microsoft Visual Studio .NET 7.1">
</head>
<body>
<table cellSpacing="1" cellPadding="1" border="1" width="100%" bordercolorlight="#ffffff"
bordercolordark="#999999" id="Table1" height="88">
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><b><font size="-1" face="Arial" color="#006699">Data Types </font></b>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><b><font size="-1" face="Arial" color="gray">Description </font></b>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">bigint </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Integer data from -2^63 through 2^63-1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">binary </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Fixed-length binary data with a maximum
length of 8,000 bytes </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">bit </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Integer data with either a 1 or 0 value </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">char </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Fixed-length character data with a maximum
length of 8,000 characters </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">cursor </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">A reference to a cursor </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">datetime </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Date and time data from January 1, 1753,
through December 31, 9999, with an accuracy of 3.33 milliseconds </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">decimal </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Fixed precision and scale numeric data
from -10^38 +1 through 10^38 -1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">float </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Floating precision number data from -1.79E
+ 308 through 1.79E + 308 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">image </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length binary data with a maximum
length of 2^31 - 1 bytes </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">int </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Integer data from -2^31 through 2^31 - 1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">money </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Monetary data values from -2^63 through
2^63 - 1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">nchar </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Fixed-length Unicode data with a maximum
length of 4,000 characters </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">ntext </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length Unicode data with a
maximum length of 2^30 - 1 characters </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">numeric </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Fixed precision and scale numeric data
from -10^38 +1 through 10^38 -1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">nvarchar </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length Unicode data with a
maximum length of 4,000 characters </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">real </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Floating precision number data from -3.40E
+ 38 through 3.40E + 38 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">smalldatetime </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Date and time data from January 1, 1900,
through June 6, 2079, with an accuracy of one minute </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">smallint </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Integer data from -2^15 through 2^15 - 1 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">smallmoney </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Monetary data values from -214,748.3648
through +214,748.3647 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">sql_variant </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">A data type that stores values of various
data types, except text, ntext, timestamp, and sql_variant </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">text </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length data with a maximum length
of 2^31 - 1 characters </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">timestamp </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">A database-wide unique number that gets
updated every time a row gets updated </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">tinyint </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Integer data from 0 through 255 </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">uniqueidentifier </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">A globally unique identifier </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">varbinary </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length binary data with a maximum
length of 8,000 bytes </font>
</p>
</td>
</tr>
<tr valign="top">
<td colspan="1" rowspan="1" valign="top" width="93">
<p><font size="-1" face="Arial" color="#006699">varchar </font>
</p>
</td>
<td colspan="1" rowspan="1" valign="top" width="348">
<p><font size="-1" face="Arial" color="gray">Variable-length data with a maximum of
8,000 characters </font>
</p>
</td>
</tr>
</table>
</body>
</html>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
Submit an article or tip