title: TSQL INTERSECT Keyword
body: <p>I have known about the SQL Server 2005/2008 keywords <a href="http://msdn.microsoft.com/en-us/library/ms188055.aspx" rel="nofollow noreferrer">EXCEPT</a> and <a href="http://msdn.microsoft.com/en-us/library/ms188055.aspx" rel="nofollow noreferrer">INTERSECT</a> for some time but have never found a compelling reason to use <code>INTERSECT</code> over the good old <code>UNION</code> keyword. </p>
  
  <p>Can anyone explain when or why you would use <code>INTERSECT</code> instead of <code>UNION</code>?</p>