
Ispirer SQLWays Database Migration Software
decimal and numeric
Numeric data types with fixed precision and scale.
decimal[(p[,s])]
Fixed precision and scale numbers. When maximum precision is used, valid values are from  10^38 +1 through 10^38  1.
p (precision) specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38. The default precision is 18 digits.
s (scale) specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision.
numeric[(p[,s])]
The numeric and decimal datatypes are identical in all respects but one: only numeric datatypes with a scale of 0 can be used for the IDENTITY column.