[dba-SQLServer] question on data types

Stuart McLachlan stuart at lexacorp.com.pg
Wed May 14 18:14:07 CDT 2008


Storage requirements.  Money and small money are effectively subsets of decimal.

Only use Decimal if you need more precision or scale than the other two can provide.

Smallmoney requires 4 bytes, money requires 8 bytes, decimal requires 9 bytes.

Stuart



On 14 May 2008 at 8:32, Susan Harkins wrote:

> Why use money or smallmoney instead of decimal? 
> 
> Susan H. 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 





More information about the dba-SQLServer mailing list