microtechpoint首席执行官创始人brian alderman mctmodule 3 sql server data types 3SQLServer数据类型FunctionOD1.pdf

ExactnumericUnicodecharacters

ApproximatenumericBinarystrings

DateandtimeOther

Characterstrings

•Decimal/numericarefunctionallyequivalentanduseprecisionand

scaleparameters:

DatatypeRangeStorage(bytes)

tinyint0to255

•smallint-32,768to32,7682

ApproximateNumeric

it2^31(2147483648)t4

DataTypeRangeStorage(bytes)

float(n)-1.79E+308to-2.23E-308,0and2.23E-308toDependsonvalueofn,4or8

1.79E+308bytes

real-3.40E+38to-1.18E-38,0and1.18E-38to

4

3.40E+38

•decimal/numeric-10^38+1through10^38–15-17

float(24)istheISOsynonymforfloat

whenumprecisionisused

▪Infloat(n),nisthenumberofbytesusedtostorethemantissaofthe

money-922,337,203,685,477.5808to8

floatnumberinscientificnotation

922,337,203,685,477.5807

smallmoney-214,748.3648to214,748.36474

•Valuesoffloataretruncatedwhenconvertedtointegertypes

DatatypeRangeStorage(bytes)

tinyint0to2551

smallint-32,768to32,7682

int