title: Transpose table with columns (sql)
body: <p>I have a table t1 with two columns c1 (int) and c2 (nvarchar). In this table always only one row.
  For example, query <code>select c1,c2 from t1</code> returns result set:</p>
  
  <pre><code>c1   c2
  ---- ----
  1    a
  </code></pre>
  
  <p>And I need transpose table with columns, so I excpect this result:</p>
  
  <pre><code>col name  value
  --------  -----
  c1        1
  c2        a
  </code></pre>
  
  <p>I have now idea, how to write this query. Hope you can help me.</p>