SQL Server Performance

numeric datatype

Discussion in 'General DBA Questions' started by jeet, Nov 21, 2005.

  1. jeet New Member


    i've got ready made table and one of it's column is having numeric and 9 lenghth,
    its precision is 10 and scale is 2,
    can anyone explain how it works?
  2. surendrakalekar New Member


    decimal and numeric
    Numeric data types with fixed precision and scale.

    decimal[(p[, s])] and numeric[(p[, s])]

    Fixed precision and scale numbers. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1. The SQL-92 synonyms for decimal are dec and dec(p, s).

    p (precision)

    Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38.

    s (scale)

    Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision.

    Precision Storage bytes
    1 - 9 5
    10-19 9
    20-28 13
    29-38 17

    Surendra Kalekar

  3. dineshasanka Moderator

  4. Madhivanan Moderator

    In SQL Server, I think Numeric and Decimal are same


    Failing to plan is Planning to fail
  5. FrankKalis Moderator

Share This Page