Stephanie Chatagner's Blog

• T-Sql

Well.

It’s about monetary values or currencies. Don’t forget to use a dot to separate partial currency units. SQL server keep in memory only the value, not the currencie associate with.

Data type Range Store
money -922 337 203 685 477,5808 <–> 922 337 203 685 477,5807 (-922 337 203 685 477,58 <–> 922 337 203 685 477,58 pour Informatica. Informatica prend uniquement en charge deux décimales, et non quatre.) 8 octets
smallmoney -214 748,3648 <–> 214 748,3647 4 octets
So, step by step and keep learning!