title: Convert one row of data in sql server to columns
body: <p>I have a query that outputs just one row of data. I want to convert that row to column and the column to row.</p>
  
  <p>My original query</p>
  
  <pre><code>------------------------
  ID     Name     Desc
  ------------------------
  1     Nisha     Some desc
  </code></pre>
  
  <p>what I need</p>
  
  <pre><code>--------------------------
  FieldName     FieldValue
  --------------------------
  ID            1
  Name          Nisha
  Description   Some Desc
  </code></pre>