sql数据类型详解（SQL data type detail）.docVIP

sql数据类型详解（SQL data type detail） SQL data type detail Bit integer Its value is only 0, 1, or null. This data type is used to store data with only two possible values, such as Yes or No, True or False, On, or Off. Int integer 4 bytes Integer from - 2^31 (-2147483648) to 2^31 (2147483647). Almost all numeric data stored in the database can be used with this data type. Smallint integer 2 bytes The smallint data type can store integers from - 2^15 (-32768) to 2^15 (32767). Tinyint integer 1 bytes The tinyint data type can store integers from 0 to 255. Numeric, decimal exact numerical type The fixed accuracy and range of numerical data from -1038-1 to 1038-1. When using this data type, range and accuracy must be specified. The range is the total number of digits that can be stored around the decimal point, and the precision is the number of digits stored on the right of the decimal point. Money currency type This data type can store data from -9220 billion to 922 billion, accurate to 1/10000 of the monetary unit. Smallmoney currency type This data type can store data from -214748.3648 to 214748.3647, accurate to 1/10000 of the monetary unit. Float floating-point numeric Any number from -1.79E+308 to 1.79E+308. Real solid type Floating point numbers between -3.40E+38 and 3.40E+38. Datetime date time type From January 1, 1753 to December 9999, 31 days, all date and time data, accurate to 1/300 seconds or 3.33 milliseconds. Smalldatetime date time type Between January 1, 1900 and June 2079, the date and time of the 6 day are accurate to one minute. Cursor special data type It contains a reference to the cursor. This data type is used in stored procedures and cannot be used when creating tables. Timestamp special data type Used to create unique numbers within a database range. Only one timestamp column can be found in a table. The value of the timestamp column changes when each row is inserted or modified. Uniqueidentifier special data type Global unique identifier, that is,