title: Adding two float variable returns integer Value in SQL Server
body: <p>I am trying to add two float variable in SQL Server but it returns integer value.It returns 1.How can I avoid this.</p>
  
  <p>I tried to casting query but it doesn't help me.</p>
  
  <p>Here I tried adding query:</p>
  
  <pre><code> CAST(STDE.d1 AS FLOAT) + CAST(STDE.d2 AS FLOAT) AS STD_e
  </code></pre>
  
  <p>How can I do this?</p>
  
  <p>Thanks</p>