title: SQL query to convert columns into rows
body: <p>I have a table as shown below.My question is:How can I convert columns into rows? I'm using Microsoft SQL Server</p>
  
  <pre><code>   sip_RECno  user1     user2    user3     user4       
  
     1          ram       ravi     sam       raj
  </code></pre>
  
  <p>i need op like below</p>
  
  <pre><code> user
   ram
   ravi
   sam
   raj
  </code></pre>
  
  <p>how to do it? thanks       </p>