, , : , ,
: bigint(
), int(
), smallint(
), tinyint(0..255) - , .
bit - SQL Server Database Engine bit. 8 bit, 1
decimal, numeric - decimal [ ( p[, s] ) ] numeric[ ( p[, s] ) ] - . numeric decimal.
money,, smallmoney - , () .
: float, real
float [ ( n ) ] - n , float . . n 1 53. n 53.
: , , datetime, datetime2, datetimepffset, smaldatetime
: char [ (n) ] - , , n . n 1 8000.
varchar [ (n | max) ]- , . n 1 8 000. max , 2^31-1 . .
text - , , . 2^31 1 (2 147 483 647)
: , , nchar nvarchar, UCS-2.
nchar [ (n) ] - n . n 1 4000.
nvarchar [ (n | max) ] - . n 1 4 000.
ntext -
: binary [ (n) ] - n , n 1 8000. n .
varbinary [ (n | max) ] - . n 1 8000;
image - , 0 2^31 1 (2 147 483 647)
: cursor - , . , cursor, NULL
hierarchyid - . .
sql_variant - , , SQL Server
table - , . uniqueidentifier - 16- GUID
xml - , XML-. xml xml
