I have a table with a column named "idEntity", if i run this query:
select idEntity from algo.AUDITORIA ;
in oracle, there's no problem and the query runs,
but in SqlServer I'm getting:
Incorrect syntax near the keyword 'from'.
it seams that IDENTITY is a reserved word, and instead of refereng to the column it thinks its a function,
and if i surround idEntity with [ ] the query works:
select [idEntity] from algo.AUDITORIA ; -- this works!
my main problem is that I'm using hibernate, is there an option to tell to hibernate to force the [ ] on every name of the table columns?