title: SQL query to get row wise total
body: <p>I'm working with SQL Server 2008. I want to get the row wise total for the table and want to merge the 2 string column names for the total column. I have below table data</p>
  
  <pre><code>Region Test  taken  Nottaken 
  India  AA    1      0 
  UK     AS    3      4 
  US     AF    1      1 
  </code></pre>
  
  <p>I want the result set like below</p>
  
  <pre><code>Region Test  taken  Nottaken Total 
  India  AA    1      0        1 
  UK     AS    3      4        7 
  US     AF    1      1        2 
  total        5      5        10
  </code></pre>
  
  <p>How to write query?</p>