title: Find number of rows of each column name
body: <p>I wrote this short script which finds a specific column name in a SQL Server database:</p>
  
  <pre><code>SELECT
      sys.columns.name AS ColumnName,
      tables.name AS TableName
  FROM
      sys.columns
  JOIN 
      sys.tables ON sys.columns.object_id = tables.object_id
  WHERE
      sys.columns.name LIKE '%ColumnName%'
  </code></pre>
  
  <p>I want to add another resulting column where number of rows of each column. </p>