Numeric(18,0)

• faravani

  SSC-Addicted

  Points: 448

  More actions

  January 5, 2010 at 10:18 pm

  #228882

  Hi For All

  Please Tell me Differnce Between int and numeric(18,0)?

  And Whats mean (18,0) in numeric(18,0)?

  Thanks For all

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  January 5, 2010 at 10:41 pm

  #1099352

  faravani (1/5/2010)

  ---

  Hi For All

  Please Tell me Differnce Between int and numeric(18,0)?

  And Whats mean (18,0) in numeric(18,0)?

  Thanks For all

  int is for Integer values as 1,2,3,4,5.... while numeric functionally acts as a deciman, if you are using numeric(18,0), it means that the total number of digits you can use is 18 without any scale or point.

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• Ray K

  SSC-Dedicated

  Points: 31172

  More actions

  January 6, 2010 at 8:04 am

  #1099593

  Check out BOL (Books Online). It should tell you the difference in further detail.

  +--------------------------------------------------------------------------------------+
  Check out my blog at https://pianorayk.wordpress.com/