title: How to find sum of multiple columns in a table in SQL Server 2005?
body: <p>I have a table <code>Emp</code> which has these rows:</p>
  
  <pre><code>Emp_cd | Val1  | Val2  | Val3  | Total
  -------+-------+-------+-------+-------
   1     | 1.23  | 2.23  | 3.43  | 
   2     | 23.03 | 12.23 | 2.92  |
   3     | 7.23  | 9.05  | 13.43 |
   4     | 03.21 | 78.23 | 9.43  |
  </code></pre>
  
  <p>I want to find <code>SUM</code> of <code>Val1, Val2, Val3</code> and which will show in the <code>Total</code> column.</p>