Field name question

15 Sep 2005 6:12 PM

Ghost Dog

Why does SQL Server change the name of a field named Level to [Level]? Level
is not a reserved word as far as I can tell, and this is creating a problem
when trying to hotsync PDAs to a SQL Server database.

15 Sep 2005 6:18 PM

Jerry Spivey

Ghost,

Level is an ODBC reserved keyword as well as a potential future SQL Server
keyword. See Reserved Keywords in the SQL Bol.

HTH

Jerry
Show quote

"Ghost Dog" <cas***@friendly.com> wrote in message
news:%23X6FJDiuFHA.908@tk2msftngp13.phx.gbl...
> Why does SQL Server change the name of a field named Level to [Level]?
> Level
> is not a reserved word as far as I can tell, and this is creating a
> problem
> when trying to hotsync PDAs to a SQL Server database.
>
>

15 Sep 2005 6:27 PM

Trey Walpole

The name has not changed - []'s are quotes for a quoted identifier.
(useful for using keywords if necessary, or multple words in a name).
The connection (oledb, odbc) might be defined to not use quoted
identifiers. If it's off, try turning it on and see if that solves the
problem.

Ghost Dog wrote:

Show quote

>Why does SQL Server change the name of a field named Level to [Level]? Level
>is not a reserved word as far as I can tell, and this is creating a problem
>when trying to hotsync PDAs to a SQL Server database.
>
>
>
>