title: column to row in sql server?
body: <p>Table:</p>
  
  <pre><code>CREATE TABLE Table1 (
    col1 INT, 
    col2 nvarchar(10), 
    col3 INT, 
    col4 INT
  );
  
  INSERT INTO Table1 
    (col1, col2, col3, col4) 
  VALUES 
    (1, 'welcome', 3, 4);
  </code></pre>
  
  <p>My table have different data type , col2 is nvarchar h can i do this ...</p>
  
  <p>result:</p>
  
  <pre><code>col    value
  ---------------
  col1   1
  col2   welcome
  col3   3
  col4   4
  </code></pre>