Microsoft SQL Server , , . - , , : , , , , .
SQL Server , , . Transact-SQL Microsoft.NET Framework.
, .
bigint | -2^63 (-9 223 372 036 854 775 808) 2^63-1 (9 223 372 036 854 775 807) | 8 |
int | -2^31 (-2 147 483 648) 2^31-1 (2 147 483 647) | 4 |
smallint | -2^15 (-32 768) 2^15-1 (32 767) | 2 |
tinyint | 0 255 | 1 |
bit - , 1, 0 NULL. SQL Server Database Engine bit, , , 8 bit, 1 . 9 16 bit, 2 ..
TRUE FALSE bit: TRUE 1, FALSE - 0.
.
decimal [ ( p[, s] ) ] numeric [ ( p[, s] ) ]
. -10^38+1 10^38-1. ISO decimal dec dec( p, s ). numeric decimal.
P ()
( , ). 1 38. 18.
s()
. 0 p. . 0; 0 <= s <= p.
.
1 - 9 | |
10-19 | |
20-28 | |
29-38 |
, ()
money | -922 337 203 685 477,5808 922 337 203 685 477,5807 | 8 |
smallmoney | -214 748,3648 214 748,3647 | 4 |
money smallmoney , .
, . , .
|
|
float | - 1,79E+308 -2,23E-308, 0 2,23E-308 1,79E+308 | n |
real | - 3,40E + 38 -1,18E - 38, 0 1,18E - 38 3,40E + 38 | 4 |
float [ ( n ) ]
n , float . . n 1 53. n 53.
n | ||
124 | 7 | 4 |
2553 | 15 | 8 |
Microsoft SQL Server , : datetime smalldatetime.
. , . , , 01-01-2010. , 01-01-2010. , .
datetime | 01.01.1753 31.12.9999 | 00:00:00 23:59:590,997 | 8 | 0,000, 0,003 0,007 |
smalldatetime | 01.01.1900 06.06.2079 | 00:00:00 23:59:59 | 4 , . | |
date | 01.01.0001 31.12.9999 | 3 , | ||
time[(0-7)] | 00:00:00 23:59:59.9999999 | 3-5 , | 100 | |
datetime2 [(0-7)] | 01.01.0001 31.12.9999 | 00:00:00 23:59:59.9999999 | 6 2 , 7 3 4 . 8 . | 100 |
Datetimeoffset[(0-7)] | 01.01.0001 31.12.9999 | 00:00:00 23:59:59.9999999 | 10 , | 100 |
datetime smalldatetime, SQL Server, , .
char [ (n) ]
, , n . n 1 8000. n . ISO char character.
varchar [ (n | max) ]
, . n 1 8 000. max , 2^31-1 . . 0 . ISO varchar charvarying charactervarying.
nchar [ (n) ]
n . n 1 4000. n . ISO nchar national char national character.
|
|
nvarchar [ (n | max) ]
. n 1 4 000. max , 2^31-1 . + 2 . 0 . ISO nvarchar national char varying national character varying.
binary [ (n) ]
n , n 1 8000. n .
varbinary [ (n | max) ]
. n 1 8000; max , 2^31-1 . 2 . 0 . ANSI SQL varbinary binary varying.