Daca ma ajutati si pe mine cu explicatii pe scurt pentru cele mai folosite tipuri de date din cele suportate de sql server 2005.Adica ma intereseaza o explicatie in limba romana doar a celor foarte utilizate.Multumesc.
|
Data Type |
Type |
Byte Size |
|
|
bigint |
Exact numeric |
8 bytes |
|
|
binary |
Binary string |
1 byte per character |
|
|
bit |
Exact numeric |
1 byte per 8 or less in table |
|
|
char |
Character |
1 byte per character |
|
|
cursor |
Transact SQL cursor |
N/A |
|
|
datetime |
Date and time |
8 bytes |
|
|
decimal |
Exact numeric |
|
|
|
float |
Approximate |
4 or 8 bytes (depending numeric on the precision) |
|
|
image |
Binary string |
2TB maximum |
|
|
int |
Exact numeric |
4 bytes |
|
|
money |
Exact numeric |
8 bytes |
|
|
nchar |
Unicode character |
2 bytes per character |
|
|
ntext |
Unicode character |
2 bytes per character and 1TB maximum |
|
|
numeric |
Exact numeric |
5, 9, 13, or 17 bytes (depending on the precision) |
|
|
nvarchar |
Unicode character |
2 bytes per character |
|
|
real |
Approximate numeric |
4 bytes |
|
|
smalldatetime |
Date and time |
4 bytes |
|
|
smallint |
Exact numeric |
2 bytes |
|
|
smallmoney |
Exact numeric |
4 bytes |
|
|
sql_variant |
Undetermined/any |
Varies with content |
|
|
table |
SQL Server table |
N/A |
|
|
text |
Character |
1 byte per character and 2TB maximum |
|
|
timestamp |
Auto-generated |
8 bytes |
|
|
tinyint |
Exact numeric |
1 byte |
|
|
varbinary |
Binary string |
1 byte per character |
|
|
varchar |
Character |
1 byte per character |
|
|
uniqueidentifier |
GUID |
16 bytes |
|
|
xml |
XML document |
2GB maximum |
|
Sorin Titu
MCITP Database Administrator
MCITP Enterprise Administrator