MS SQL Server 2000 system data type:
(from SQL Query Analyzer)
1bigint Integer (integer) data from -2^63 to 2^63-1
2binary fixed-length binary data, up to 8,000 bytes
3bit integer data with a value of 1 or 0
4char fixed-length non-Unicode character data, 8,000 characters long
5cursor the data type used for a variable or stored procedure output parameter that contains a reference to a cursor
6datetime date and time data, from January 1, 1753 to December 31, 9999
7decimal fixed-point precision and decimal numeric data, from -10^38-1 to 10^38-1
8float floating-point precision numeric data, from -1.79E+308 to 1.79E+308
9image binary data of variable length, up to 2^31-1 bytes
10int Integer (integer) data from -2^31 to 2^31-1
11money monetary data value, from -2^63 to 2^63-1, accuracy to 1 per thousand of monetary unit
12nchar fixed-length Unicode data, 4,000 characters long
13ntext of variable Unicode data with a maximum of 2^30-1 characters
Synonyms for 14numeric decimal
15nvarchar of variable Unicode data with a maximum of 4,000 characters
16real floating-point precision numeric data, from -3.40E+38 to 3.40E+38
17rowversion database-wide unique number
18smalldatetime date and time data, from January 1, 1900 to June 6, 2079
19smallint integer data from -2^15 to 2^15-1
20smallmoney monetary data value, between -214,748.3648 and +214,748.3647
21sql_variant can store data types for values of a variety of SQL Server-supported data types.
22 without storing the values of text, ntext, timestamp, and sql_variant types
23sysname System-supplied user-defined data type, synonymous with nvarchar (128)
24table a special data type that can be used to store result sets for later processing
25text of variable-length non-Unicode data, maximum 2^31-1 characters
26timestamp database-wide unique number
27tinyint integer data from 0 to 255
28uniqueidentifier globally unique identifier (GUID)
29varbinary binary data of variable length, up to 2^31-1 bytes
30varchar of variable-length non-Unicode data, up to 8,000 characters long
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
