. , . SQL- : , , ..
- , , .
, SQL-. LPS . ((- , - ) Length, Precision Scale SQL Server Enterprise Manager .
6
LPS | ||
Char | , , . : 8000 . | |
Nchar | Char, . : 4000 . | |
Varchar | . : 8000 . | |
Nvarchar | Varchar, . : 4000 . |
6
LPS | ||
Char | , , . : 8000 . | |
Nchar | Char, . : 4000 . | |
Varchar | . : 8000 . | |
Nvarchar | Varchar, . : 4000 . |
7
LPS | ||
Int | , , ' 4 . ij: 231 +2331. | |
Smallint | ' 2 . Int, . ij: -32768 32767. | |
Tinyint | , , ' 1 . ij: 0 255. | |
Real | , , , 7 ; ' 4 . ij: -3,4-38 +3,4+38. | |
Float | , , , 15 ; ' 8 . ij: -1,7-308 +1,7+308. | |
Decimal | | , , , ' 2 17 . ij: 10-38 +10+38 |
Numeric | | Decimal |
Money | , , ' 8 . ij: 922337203685477.5808 +922337203685477.5807. | |
Small-money | Money, ' 4 . ij: 214748.3648 +214748.3647 |
|
|
8
LPS | ||
Date time | ooo | , , ' 8 . ij: 01.01.1753 31.12.9999. |
Small-date time | ooo | Datetime, ' 4 ij: 01.01.1900 06.06.2079. |
9
LPS | ||
Bit | ooo | , , : 0 1; ' 1 . ij: 0 1. |
Binary | oo | , . : 8000 . |
Varbinary | oo | , , Binary. : 8000 . |
Timestamp | ooo | , . |
Uniqueidentifier | ooo | 16- QUID (Globally unique identifier), . SQL NEWID() |