title: Index with Include in SQL Server
body: <p>What's the difference between</p>
  
  <pre><code>CREATE NONCLUSTERED INDEX IX_NAME1 ON TABLE1 (A) INCLUDE (B,C)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>CREATE NONCLUSTERED INDEX IX_NAME1 ON TABLE1 (A,B,C)
  </code></pre>
  
  <p>And what <code>SELECT</code> query will show me this difference?</p>