Select table with column named "index"

sql sql-server sql-server-2008 sql-server-2008-r2

Use square brackets to quote reserved words:

select id, [index]from item

See also the documentation on Delimited Identifiers.

sql sql-server sql-server-2008 sql-server-2008-r2

Put reserved words in brackets:

select id, [index]from item

sql sql-server sql-server-2008 sql-server-2008-r2

Try this

SELECT id, [index] FROM item

Reserved words used as names in SQL-Server must be enclosed in brackets.

CodeHunter