title: Select rows using EXCEPT - SQL Server
body: <p>How can I return just different columns when I use <code>except</code> in SQL Server?</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT ID, NAME FROM TABLE_B
  EXCEPT
  SELECT ID, NAME FROM TABLE_A
  </code></pre>
  
  <p>In this case, if there is different name return just show name column.</p>