Alternative datatype to numeric(9, 0)

• tomiz

  SSCommitted

  Points: 1842

  More actions

  July 23, 2002 at 10:14 am

  #158746

  Hi all!

  I just found out that with the numeric datatype you can use negative numbers too! Well, I only use the positive ones! So, doesn't the field take up double the bytes needed?? If it does... what should I use then?

  Thanks for any help!

  /Tomi

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  July 23, 2002 at 4:35 pm

  #433264

  Set a constraint. Same size, less scale.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• tomiz

  SSCommitted

  Points: 1842

  More actions

  July 24, 2002 at 9:00 am

  #433295

  Hello Steve!

  Sorry, but I don't know what that means. Could you please give me an example.

  /Tomi