title: How to select an sql index
body: <p>How to select an sql index </p>
  
  <p>I have an table TabEmp with fields <code>c_ID (primary key)</code>, and <code>c_Emp_ID</code>.</p>
  
  <p>I created an index on it <code>idx_TabEmp (non-clustered)</code> with the fields <code>c_ID (primary key)</code> and <code>c_Emp_ID</code></p>
  
  <p>I am using select statement </p>
  
  <pre><code>select * from index = idx_TabEmp 
  </code></pre>
  
  <p>It throws an error</p>
  
  <pre><code>Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax
  </code></pre>
  
  <p>I am using </p>
  
  <pre><code>select * from TabEmp (index = idx_TabEmp)
  </code></pre>
  
  <p>it works, but I am not sure if that is the correct way to select an index</p>
  
  <p>Can you please tell me the correct way to query an index?</p>