title: find all columns of specified type in database
body: <p>I have SQL server 2008 R2. I want to get column name and table name where this columns is situated. And that i want to display for specified type. For example:
  let's say i want to see all tinyint columns. The result should be the following:</p>
  
  <pre><code>ColumnName|TableName
  orderID   |Orders
  clientID  |Orders
  refID     |discounts
  </code></pre>
  
  <p>Is it possible to write query to do that? </p>