samalex (12/20/2012)

---

Technically FLOAT, REAL, MONEY and SMALLMONEY all have different ranges, but my standard is just to convert all numeric values of different types, especially values with currency, to Numeric(17,2), and for percents I use Numeric(17,6). Doing this keeps all numeric values standard across the database.

Also Numeric and Decimal are equivalents, I just have always used Numeric, but you can use Decimal just the same.

Hope this helps ..

Sam