||SQL Server Tips by Gama and Naughter
Money and smallmoney
Money can store numbers between -2^63 and 2^63 – 1, that is
-922,337,203,685,477.5808 to +922,337,203,685,477.5807, with
accuracy to a ten-thousandth of a monetary unit.
Smallmoney can store numbers between -2^31 and 2^31 – 1, that is
-214,748.3648 to +214,748.3647, with accuracy to a ten-thousandth of
a monetary unit.
DECLARE @m smallmoney
SELECT @m, DATALENGTH(@m)
SELECT CAST(@m as binary(4))
075BCCBC in decimal is 123456700 which divided by 10,000 is
The above book excerpt is from:
Turbocharge Database Performance with C++ External Procedures
Joseph Gama, P. J. Naughter