Post reply

Datatype for money - apart from money

  • July 1, 2003 at 8:14 am

    #80387

    Could anyone tell me what would be the best data type to use for storing monetary values apart from money and smallmoney data types.

    Any suggestions and explanations would be a huge help.

    Thank you,

    regards.

  • July 1, 2003 at 8:46 am

    #463782

    We use numeric(14,2). We rely on our application code to handle all of the rounding. This data type is preferred because "money" is specific to SQL Server and would be more difficult to port to a different database platform if needed.

    Darren


    Darren

  • July 1, 2003 at 8:56 am

    #463786

    Thanks for your reply, Darren.

    Before you replied, i opted for decimal.

    Is there much (if at all any) difference between numeric and decimal that you know of? I have tried to read BOL, but can't seem to see a major difference between them.

  • July 1, 2003 at 8:58 am

    #463787

    Nope, they are the same thing. You'll be fine with decimal.

    Darren


    Darren

  • July 2, 2003 at 1:13 am

    #463874

    Thanks again, Darren.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply