A giant integer, which is an eight-section integer with an accuracy of 19 bits. Macro integers range from-9,223,372,036,854,775,808 to.
9,223,372,036,854,775,807。
binary
binary system
a little
byte
tea
character type
testing time
Time type
decimal
Decimal data type Decimal variables are stored as unsigned integers of 96 bits (12 bytes) and divided by the power of 10.
This scale factor determines the number of digits to the right of the decimal point, ranging from 0 to 28. When the scale factor is 0 (no decimal places),
The maximum possible values are+/-79,228,162,514,264,337,593,543,950,335. For 28 decimal places, the maximum value is
+/-7.922816251426437593543950335, and the minimum non-zero value is+/-0.0000000000000000001.
flotage
Single precision type
picture
Picture type
Internationalorganizations (same as international organizations)
Do plastic surgery
money
Currency type
Enchar
Returns a unicode character with a given integer code according to a character type defined by the unicode standard.
ntext
Text type
digital
Decimal(numeric) is a synonym for accurately storing numerical values.
The decimal data type can store up to 38 numbers, all of which can be placed to the right of the decimal point. Decimal data type storage
Accurate digital expression; Do not store approximations.
nvarchar
Varchar character data type.
real
Floating-point and actual data
Floating-point and real data types are called approximate data types. In terms of approximate numeric data types, floating-point and real data are used as follows.
Follow the IEEE 754 standard.
smalldatetime
Short date type
smallint
Short integer
Small fund
Short-term currency type
Sql _ variable
A data type used to store various data types supported by SQL Server (excluding text, ntext, image, timestamp and
Sql_variant)。
text
text
time stamp
/f? Kz=9 10620 16 is introduced here.
tinyint
Tinyint uses the exact numeric data type of integer data, ranging from 0 to 255, and stores 1 byte.
Unique identifier
The uniqueidentifier data type can store a binary value of 16 bytes, which is similar to globally unique identifier (GUID). GUID is unique.
Binary number: No two computers in the world will generate duplicate GUID values. GUID is mainly used for multi-node and multi-computer computing.
In a computer network, a task must have a unique identifier. In SQL, ROWGUIDCOL means that the new column is the globally unique identification column of the row. about
Only one uniqueidentifier column can be assigned to each table as ROWGUIDCO column. The ROWGUIDCOL property can only be assigned to uniqueidentifier.
row
Uniqqueidentifier is a globally unique identifier.
varbinary
Variable length binary data. N can be a value between 1 and 8,000. Max indicates that the maximum storage size is 2 3 1- 1 byte. Large storage capacity
As small as the actual length of input data +2 bytes. The length of the input data can be 0 bytes. ANSI SQL Synonym for Varbinary
This word is binary.
Variable length string
Variable length non-unicode character data. The value range of n is 1 to 8000. Max indicates that the maximum storage size is 2 3 1- 1 byte.
. The storage size is the actual length of the input data plus 2 bytes. The length of the input data can be 0 characters. Varchar's ISO and
Semantic words are character-changing or character-changing.
That's basically it.