Results 1 to 8 of 8

Thread: SQL Server Precision Scale

  1. May 31st, 2002, 08:03 AM #1
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479

    SQL Server Precision Scale

    If a field is an integer in SQL Server with the precision scale set to 4, what is the largest number it can hold?
    Reply With Quote Reply With Quote
  2. May 31st, 2002, 08:38 AM #2
    skald2k
    skald2k is offline
    Fanatic Member skald2k's Avatar
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    535
    9999
    - If at first you dont succeed, then give up, cause you will never will!
    Reply With Quote Reply With Quote
  3. May 31st, 2002, 08:39 AM #3
    Buzby
    Buzby is offline
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670
    Integers: (-2,147,483,648) - (2,147,483,647) (same as VB Long)
    SmallInt: (-32768) - (32767) (same as VB Integer)
    TinyInt: (0) - (255)
    'Buzby'
    Visual Basic Developer
    "I'm moving to Theory. Everything works there."
    Reply With Quote Reply With Quote
  4. May 31st, 2002, 08:42 AM #4
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    Who's right?
    Reply With Quote Reply With Quote
  6. May 31st, 2002, 09:47 AM #5
    DeadEyes
    Guest
    A length of 4 means 4 bytes so numbers from -2,147,483,648 through 2,147,483,647. is right
    Reply With Quote Reply With Quote
  7. May 31st, 2002, 09:51 AM #6
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    Well done Scald2k
    MSDN
    Reply With Quote Reply With Quote
  8. May 31st, 2002, 10:02 AM #7
    DeadEyes
    Guest
    boy is my face red, while being technically right about the length i should really learn to read the questions
    Reply With Quote Reply With Quote
  9. Jun 6th, 2002, 07:53 AM #8
    Buzby
    Buzby is offline
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670
    From MSDN:

    For example, an int data type can hold 10 digits, is stored in 4 bytes, and does not accept decimal points. The int data type has a precision of 10, a length of 4, and a scale of 0.
    You can't change the precision, length or scale of an Integer in SQL Server... can you?
    'Buzby'
    Visual Basic Developer
    "I'm moving to Theory. Everything works there."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width