sqlsql-servert-sqlinteger-division

Why does division return zero

Here is the code I'm using in the example:

 PRINT @set1
 PRINT @set2

 SET @weight= @set1 / @set2;
 PRINT @weight

Here is the result:

47
638
0

I would like to know why it's returning 0 instead of 0,073667712

Solution

  • Either declare set1 and set2 as floats instead of integers or cast them to floats as part of the calculation:

    SET @weight= CAST(@set1 AS float) / CAST(@set2 AS float);