sql字段类型（国外英文资料）.doc

sql字段类型（国外英文资料） The field type of the SQL SERVER is shown in the field type of the version above SQL SERVER7.0. The field type of SQL SERVER6.5 shows the instructions provided by SQL SERVER. Bit: integer value of 0 or 1 Int: from 2 ^ 31 (2147483648) to 2 ^ 31 (2147483647) of integer Numbers Smallint: from 15 (32768) to 2-2 ^ ^ 15 (32767) of integer Numbers Tinyint: integer from 0 to 255 A decimal: from 38 to 10-10 ^ ^ the accuracy of 38-1 and the number of significant digits Numeric: synonymous with a decimal Money: from - 2 ^ 63-922337203685477580 (8) to 2 ^ 63-1 (922337203685477580) currency data, the smallest unit of currency in ten over one thousand Smallmoney: currency data from -214,748.3648 to 214,748.3647, the smallest unit of currency is ten thousand Float: the number of variable accuracy from -1.79e+ 308 to 1.79e+ 308 Real: the number of variable accuracy from -3.04e+ 38 to 3.04e+ 38 Datetime: from January 1, 1753 to the date and time data of the 12th of 9999, the minimum time unit is 3% or 3.33 milliseconds Smalldatetime: date and time data from January 1, 1900 to June 6, 2079 Timestamp: the time stamp, the only number for a database width Uniqueidentifier: the global unique identifier GUID Char: fixed long non-unicode character data with maximum length of 8000 Varchar: a long non-unicode character data with a maximum length of 8000 Text: the longer the Unicode character data, the maximum length is 2 ^ 31-1 (2 g) Nchar: fixed-length Unicode character data with maximum length of 8000 Nvarchar: Unicode character data with maximum length of 8000 Longer ntext: Unicode character data, the maximum length is 2 ^ 31-1 (2 g) Binary: fixed-length binary data with maximum length of 8000 Varbinary: longer binary data, maximum length of 8000 Image: variable-length binary data, the maximum length is 2 ^ 31-1 (2 g) INTEGER data type INT or INTEGER SMALLINT TINYINT BIGINT The floating point data type REAL FLOAT DECIMAL NUMERIC BINARY data type BINARY VARBINARY Logical da