SQL, Store currency values as Money, Float, or Int?
Posted on 2008-11-08
I'm writing a program for processing stocks (doesn't everyone at some point or another?).
These are U.S. stocks, priced in dollars and cents, with penny stocks sometimes priced to a tenth of a cent.
These values could be typed as money, float, or int (multiply by 1000 before storing).
Are there performance advantages to storing as scaled integers? Are there disadvantages? I'm using SQL Server Express 2005.
I'd like some advice.