title: How to sum columns in SQL Server?
body: <p>I am trying to create a column that is the total value of column A,B,C,D,E.</p>
  
  <pre><code> select,[TVIncome] a
    ,[XIncome] b
    ,[ZIncome] c
    ,[DINCOME] d
    ,[OIncome] e
  </code></pre>
  
  <p>sum(a,b,c,d,e) as total</p>
  
  <p>The error I get when doing the above sum is :"The sum function requires 1 argument(s)."</p>
  
  <p>The total above does not work. Also, if I just include the the proper names, XIncome and the rest,it still does not work. How do I do it?</p>