If you have a column called index, as index is a keyword, attempting to select based on that will fail because there are insufficient quoting rules for the column.
The work around is to alias the query with a view, or to list out each field and use AS in the list. Neither of which are ideal.
If you have a column called
index, as index is a keyword, attempting to select based on that will fail because there are insufficient quoting rules for the column.The work around is to alias the query with a view, or to list out each field and use AS in the list. Neither of which are ideal.