Compare 2 big tables (SQL Server)
<p>I have 2 big tables(About 100-150k rows in each). </p>

<p>The structure of these tables is the same. Ids of entities are also the same in each table.</p>

<p>I need a very fast way to compare these tables and answer the following questions:</p>

<ol>
<li>Which row's fields are different from another table's row?</li>
<li>Which ids exists in first table and doesn't exists in second table?</li>
<li>Which ids exists in second table and doesn't exists in first table?</li>
</ol>

<p>Thank you!</p>

<p><strong>Edit:</strong> I need to do this comparison using C# or maybe stored procedures(and then to select results by c#)</p>