Best practice datatypes

HI all,
Which ould be the best datatype to use. I have possibilities of monetory
values from 0 to 1000000000
I've heard that the money datatype is not readily used. Should I use
numeric. What do you guys use
Thanks
RobertRobert Bravery wrote:
> HI all,
> Which ould be the best datatype to use. I have possibilities of monetory
> values from 0 to 1000000000
> I've heard that the money datatype is not readily used. Should I use
> numeric. What do you guys use
> Thanks
> Robert
Not MONEY or SMALLMONEY. See:
http://groups.google.co.uk/group/mi...718f3de3?hl=en&
DECIMAL or INTEGER should be suitable in your case.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks David,
Very informative, I never knew this was the case
Thanks
Robert
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1139567259.859890.220900@.g14g2000cwa.googlegroups.com...
> Robert Bravery wrote:
> Not MONEY or SMALLMONEY. See:
>
http://groups.google.co.uk/group/mi...rogramming/msg/
df52c1b2718f3de3?hl=en&
> DECIMAL or INTEGER should be suitable in your case.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>