title: SQL Server - use count function with intersect
body: <p>How to count the result of this query?</p>
  
  <pre><code>SELECT id FROM table1 where  col1 like '%abcd%'
  intersect
  SELECT id from table2 where col2 like '%efgh%'
  </code></pre>