Prev: C# and SQL Server: Parallel vs. Sequential Writes (?)
Next: Transfer file from Access to Server
From: Sam on 17 Feb 2010 22:54
Is there a link available for reservered words

Can a field be named GROUP
or is it a reservered word?

TIA


From: --CELKO-- on 17 Feb 2010 23:00
GROUP is a reserved word and should not be used for a column (NOT
field) name. Besides that, it is also too vague -- group of what?

I can post a list of the ANSI/ISO words when I get home. It is pre3tty
long. Someone else will have a SQL Server list, I am sure.
From: Jay on 17 Feb 2010 23:03
http://msdn.microsoft.com/en-us/library/aa238507(SQL.80).aspx

"Sam" <sam(a)nospamme.biz> wrote in message
news:uv12Y4EsKHA.5036(a)TK2MSFTNGP02.phx.gbl...
> Is there a link available for reservered words
>
> Can a field be named GROUP
> or is it a reservered word?
>
> TIA
>


From: Plamen Ratchev on 17 Feb 2010 23:05
Yes, GROUP is reserved keyword. Here is the list:
http://msdn.microsoft.com/en-us/library/ms189822.aspx

--
Plamen Ratchev
http://www.SQLStudio.com
From: Tom Cooper on 17 Feb 2010 23:06
GROUP is a reserved word. You can, but should not name a column GROUP. If
you do, you have to enclose it in brackets every time you reference it.
For example,

create table #t ([GROUP] int);
select [GROUP] from #t;

It's legal, but don't do it.

Reserved word lists:
SQL 2008
http://msdn.microsoft.com/en-us/library/ms189822.aspx
SQL 2005
http://msdn.microsoft.com/en-us/library/ms189822%28SQL.90%29.aspx
SQL 2000
http://msdn.microsoft.com/en-us/library/aa238507%28SQL.80%29.aspx

Tom

"Sam" <sam(a)nospamme.biz> wrote in message
news:uv12Y4EsKHA.5036(a)TK2MSFTNGP02.phx.gbl...
> Is there a link available for reservered words
>
> Can a field be named GROUP
> or is it a reservered word?
>
> TIA
>

 |  Next  |  Last
Pages: 1 2 3 4
Prev: C# and SQL Server: Parallel vs. Sequential Writes (?)
Next: Transfer file from Access to Server