title: SQL Server truncates decimal points of a newly created field in a view
body: <p>I have a view in SQL server, something like this:</p>
  
  <pre><code>select 6.71/3.41 as NewNumber
  </code></pre>
  
  <p>The result is <code>1.967741</code> (note 6 decimal points) -> <code>decimal (38,6)</code></p>
  
  <p>I try the same thing in a calculator but the result is <code>1.967741935483871xxxx</code></p>
  
  <p>I want to force SQL Server to return more accurate result something like <code>decimal(38,16)</code>
  I have tried the obvious things like casting, but SQL Server doesn't improve the output I just get some trailing zeros at the end like <code>1.9677410000</code></p>
  
  <p>Is there a way to force SQL Server to not truncate the result or give more accurate one?</p>