Re: Scale option not available
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 15 Aug 2006 17:06:51 -0600
The precision and scale for money is fixed and not user
defined in SQL Server.
If for some reason you need a different precision and scale
from what money uses, you will need to change the data type
to decimal (or numeric) data type.
-Sue
On Tue, 15 Aug 2006 14:05:02 -0700, Derrick
<Derrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a database I converted from Access that has a column formatted as
money. Before the conversion the number of decimal places was set at 2 but
somewhere along the way it became 4. However, I am unable to change the
scale as that option is not available.
I am relatively new to SQL Server 2005, so there may be something simple I
am missing. Thanks for the help in advance.
.
- Prev by Date: Re: SqlServer *much* slower waking up than MySQL...change what con
- Next by Date: RE: security
- Previous by thread: administering new installation of MS SQL Server 2005
- Next by thread: Re: Exact use of Log file - why so big?
- Index(es):
Relevant Pages
|
