title: Retrieve the value with Column name and corresponding Values in T-SQL
body: <p>I need a select statement which will give column name in first result column and the corresponding value in next result column of the Query. the image refers the sample table.
  <a href="http://i.stack.imgur.com/y9s5c.jpg" rel="nofollow">Test Table</a></p>
  
  <p>when i retrieve the value for the ID 1 from test table. It has to give the result set like </p>
  
  <p><a href="http://i.stack.imgur.com/e1t5Q.jpg" rel="nofollow">Result set</a></p>
  
  <p>I need to get an appropriate result even the column name is different no similar prefix or suffix in the column name. i do not want to change the Query to get the result even if Columns in the table are modified means added/removed.</p>