I am working on this old SQL Server database which store numeric values in
MONEY datatype. This has been good for years, now for some currency rate conversions we need up to 10 decimal places. We are exploring the possible conversion from
MONEY datatype to
I see that a
MONEY field is equivalent to a
DECIMAL(19, 4). Would it be safe just use a broader
DECIMAL(25, 10) to accommodate 10 decimal digits?
What if we want ensure more space for future request, what would be the limit that would not fit anymore the Classic ASP application built on the database (using