In SGI FORTRAN77, “Real*8” is a real number with 8 bytes of storage, and “Real*16” is a real number with 16 bytes of storage. So in SQLServer 2000, the default decimal type “decimal(18,0)” in Management Studio and in Enterprise Manager, is a decimal with 18 bytes of storage, right? Today, I heard a lot of “Hey Greg, why are my interest rates rounding to the nearest percent?”
OK, it wasn’t a big deal and it was easily changed once somebody noticed. And I know I shouldn’t be letting FORTRAN experience guide me in the ways of SQL Server. But why does the default decimal in SQL Server effectively give you an integer?