Post reply

Updating number accuracy

  • July 27, 2005 at 2:43 am

    #69491

     

    Hi there,

    I have a basic question:

    I have many tables with numbers in them having 8 digit after the decimal point accuracy.  I want to update the data so that they have only 2 digits after the decimal point accuracy.  The data I wish to deal with is in a certain column.  How can I do that? 

    Thanks a lot.

     

    Liron

  • July 27, 2005 at 2:53 am

    #577459

    You can just change the table design using Enterprise Manager. Look up the decimal datatype in Books Online.

    If you don't want to change the table design, then you'll need to use the CAST function wherever you use the data. EG: CAST(<yourcolumn> as decimal(<your precision>,2))

     

    --------------------
    Colt 45 - the original point and click interface

  • July 27, 2005 at 3:10 am

    #577465

    You can change the column scale to 2

    from

    killer

Viewing 3 posts - 1 through 2 (of 2 total)

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