math with sql

• foxjazzG

  SSCrazy

  Points: 2221

  More actions

  January 9, 2009 at 3:52 pm

  #203947

  When doing math with sql server, why doesn't it default to return real numbers?

  select 2621475 / 65535

  returns 40

  How do you get the remainder?

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 9, 2009 at 4:19 pm

  #924683

  If you mean a true remainder, this will give it:

  select 2621475%65535

  If you actually mean you want to see the decimal fraction, this will give it:

  select 2621475./65535.

  As to why, you should read about math operations in SQL Server Books Online, but the short answer is that the code you posted is integer math and so it returns an integer result. If you want a numeric or floating point result, cast the values to that before performing the math.