title: Select table with column named "index"
body: <p>I have a table with a column name called "index"</p>
  
  <pre><code>select id, index
  from item;
  </code></pre>
  
  <p>gives an error:</p>
  
  <blockquote>
    <p>Msg 1018, Level 15, State 1, Line 1 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.</p>
  </blockquote>
  
  <p>How can I do a select on a column named index? I'm using sqlserver 2008-R2</p>