数据类型 | 存储尺寸 | 描述 |
bigint | 8 bytes | |
integer | 4 bytes | |
smallint | 2 bytes | |
tinyint | 1 byte | |
bit | 1 byte | |
numeric(p,s) decimal(p,s) dec(p,s) | 19 bytes | |
money | 8 bytes | |
float | 8 bytes | |
real | 4 bytes | |
datetime | 8 bytes | |
nvarchar(n) | 2*长度 bytes | |
ntext | 2*长度 bytes | |
nchar | 2*长度 bytes | |
binary(n) | 长度 bytes | |
varbinary(n) | 长度 bytes | |
image | 长度 bytes | |
uniqueidentifier | 16 bytes | |
IDENTIFY[(s,i)] | - | |
ROWGUIDCOL | - | |
Timestamp/rowversion | 8 bytes |
SQL Server中各数据类型尺寸(Byte)
最新推荐文章于 2019-03-25 14:30:06 发布