[dba-SQLServer] question on data types

Susan Harkins ssharkins at gmail.com
Wed May 14 18:59:20 CDT 2008


Okay -- that makes sense. Thanks!

Susan H.


> 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
>>
>
>
> _______________________________________________
> 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