Money vs Decimal(9,2)
Precision defines total length of the number. Scale represents only position of the delimiter. Decimal(9, 2) will store numbers like 1234567.89 that is 9 digits so it will be 5 bytes.
Decimal(9,2) = X,XXX,XXX.XX
Money vs Decimal(9,2)
Precision defines total length of the number. Scale represents only position of the delimiter. Decimal(9, 2) will store numbers like 1234567.89 that is 9 digits so it will be 5 bytes.
Decimal(9,2) = X,XXX,XXX.XX
Comments