title: Converting Columns into rows with their respective data in sql server
body: <p>I have a scenario where I need to convert columns of table to rows 
  eg - 
  table - stocks:</p>
  
  <pre><code>ScripName       ScripCode       Price   
  -----------------------------------------
  20 MICRONS      533022      39  
  </code></pre>
  
  <p>I need to represent the table in the following format, but I just need this kind of representation for single row </p>
  
  <pre><code>ColName       ColValue
  -----------------------------
  ScripName      20 MICRONS
  ScripCode      533022    
  Price          39
  </code></pre>
  
  <p>so that I can directly bind the data to the datalist control.</p>