title: SQL Select including Data type and Data values
body: <p>How could I select data from a table and include the data type with the values?
  For example, I have table called EMPLOYEE with fname, lastname, phone, etc.
  If I do:</p>
  
  <pre><code>SELECT * FROM EMPLOYEE
  </code></pre>
  
  <p>I get all the columns. If I do: </p>
  
  <pre><code>SELECT COLUMN_NAME, DATA_TYPE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME = 'EMPLOYEE'
  ORDER BY ORDINAL_POSITION
  </code></pre>
  
  <p>I get all the column names and their data types.</p>
  
  <p>I need to combine these two so I have the values displayed along with the data type.</p>
  
  <p>I'm new to SQL but I have searched on the web some and tried various JOIN and UNION statements, but I could just be entering them wrong.  </p>