what is the largest number can be in a column "int"?

Discussion in 'Databases' started by wacamoi, Feb 28, 2009.

0
  1. #1
    does someone know MSsql "int" can accept how large size of number?

    is 999,999 or 9,999,999 or 99,999,999

    thanks
     
    wacamoi, Feb 28, 2009 IP
  2. Teelo

    Teelo Peon

    Messages:
    14
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    The range for an int is from -2^31 to 2^31-1, that is a 32-bit signed
    number.

    2147483647
     
    Teelo, Feb 28, 2009 IP
    wacamoi likes this.
  3. wacamoi

    wacamoi Peon

    Messages:
    810
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thank you Teelo,

    what will happen if a query is bigger than 2147483647 ?

    any way to solve the problem?
     
    wacamoi, Feb 28, 2009 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Make it unsigned.
     
    mwasif, Mar 1, 2009 IP
  5. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #5
    unsigned, or use a bigint...

    Unless you plan on allowing negative numbers, it's better to use unsigned anyway.
     
    jestep, Mar 2, 2009 IP