title: Why does SQL Server round off results of dividing two integers?
body: <p>I have a table with a smallint column that contains percentages as whole numbers (i.e., 50, 75, 85, etc.)</p>
  
  <p>When I divide this column by 100, as in</p>
  
  <pre><code>SELECT MY_COLUMN/100 AS PCT_AS_FRACTION
  FROM MY_TABLE
  </code></pre>
  
  <p>the result is rounded to the nearest whole number.
  For example, for a row that contains the number "50", I get zero as my result.</p>
  
  <p>I can duplicate this with a simple statement:</p>
  
  <pre><code>SELECT 50 / 100 AS TEST_VALUE
  </code></pre>
  
  <p>Why is that, and how can I get more precision in my result?</p>