title: Can I combine the results from multiple columns into a single column without UNION? in SQL Server 2012
body: <p>I want to combine 2 column output into one column.</p>
  
  <p>Example :</p>
  
  <pre><code>select 1 as id, 2 as exid 
  </code></pre>
  
  <p><strong>Current</strong> output:</p>
  
  <pre><code>id | exid 
  1  |    2
  </code></pre>
  
  <p>but I want output like the following : </p>
  
  <pre><code>id
   1
   2
  </code></pre>
  
  <p>If I use <code>Concat</code> function then output looks like this : </p>
  
  <pre><code>id  
  12 
  </code></pre>
  
  <p>and I don't want to this type of output.</p>
  
  <p><strong>Note</strong> : I don't want to use <code>UNION</code> function.</p>