Re: Syntax coloring: SERVICE

Gail,

Why isn't SERVICE in the list of T-SQL reserved words in BOL 2005? (I
guess it's not a reserved word even though it gets colored blue.)
It probably should be. I've filed a doc bug for this issue. Thanks for reporting this.

You might want to cancel that. SERVICE isn't a keyword (*) and it is SSMS that has it the wrong way. Check out Roger Wolters book on SB, page 59-60 and you'll see that they designed it so that some of the new language constructs aren't actually keywords. Roger talks about SEND and RECEIVE but SERVICE seems to be in that category. In below script, there is no error message, even though I'm not delimiting the word SERVICE:

USE tempdb
CREATE TABLE SERVICE (c1 int)
SELECT * FROM SERVICE

(*) One could of course get into the debate of what a keyword really is. I don't know, perhaps a keyword can work as an un-qualified identifier, while others can't. I'll leave that for you to investigate. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx> wrote in message news:urgXkIh$GHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
Where is this documented? Why doesn't the word SERVICE have an index entry
in BOL 2005?
You're not getting anything returned in the index on the word 'service'? In the most recent update to BOL, the index returns the following choices when SERVICE is the keyword.
service See services [Analysis Services]
service See services [Integration Services]
service See services [Notification Services]
service See services [Reporting Services]
service See services [Service Broker]
service See services [SQL Server]

Or where you expecting to see something like this in the index?

SERVICE
ALTER
CREATE
DROP

If so, we could consider doing that in a future update, but for now you would be better off using more complete phrases in the index like 'CREATE SERVICE' or 'DROP SERVICE'.

Why isn't SERVICE in the list of T-SQL reserved words in BOL 2005? (I
guess it's not a reserved word even though it gets colored blue.)
It probably should be. I've filed a doc bug for this issue. Thanks for reporting this.

And why, if anyone knows, does sending feedback on BOL 2005 fail with:

<sqldocfb@xxxxxxxxxxxxx>:
205.248.106.30 does not like recipient.
Remote host said: 550 5.1.1 User unknown

I suspect this is a transient error, but I've forwarded your e-mail to the appropriate team for further evaluation.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx


"DWalker" <none@xxxxxxxx> wrote in message news:edo4A2g$GHA.1556@xxxxxxxxxxxxxxxxxxxxxxx
"Arnie Rowland" <arnie@xxxxxxxx> wrote in
news:OvVsbCT$GHA.3260@xxxxxxxxxxxxxxxxxxxx:

[Service] is an object that you can create, drop, and use. Therefore
it is also a T-SQL keyword.


Where is this documented? Why doesn't the word SERVICE have an index entry
in BOL 2005?

Why isn't SERVICE in the list of T-SQL reserved words in BOL 2005? (I
guess it's not a reserved word even though it gets colored blue.)

And why, if anyone knows, does sending feedback on BOL 2005 fail with:

<sqldocfb@xxxxxxxxxxxxx>:
205.248.106.30 does not like recipient.
Remote host said: 550 5.1.1 User unknown

???

Thanks.

David



.

Relevant Pages

  • Re: Syntax coloring: SERVICE
    ... SQL Server Documentation Team ... guess it's not a reserved word even though it gets colored blue.) ... One could of course get into the debate of what a keyword really is. ... In the most recent update to BOL, the index returns the following choices ...
    (microsoft.public.sqlserver.tools)
  • Re: Syntax coloring: SERVICE
    ... Why do you assume that it is not documented in Books Online? ... Why don't you notice that there are many index entries for SERVICE in ... I did NOT assume it was not documented in BOL, ... It should be listed in the reserved word list if it's a reserved word. ...
    (microsoft.public.sqlserver.tools)
  • Re: Append to Table with Indexed Field
    ... BTW, the word IN is a reserved word, so not a choose idea for a table name. ... Allen Browne - Microsoft MVP. ... second table "BOL Control". ...
    (microsoft.public.access.queries)
  • Re: Append to Table with Indexed Field
    ... you will need to know some VBA code to achieve this. ... BTW, the word IN is a reserved word, so not a choose idea for a table ... second table "BOL Control". ...
    (microsoft.public.access.queries)
  • Re: Syntax coloring: SERVICE
    ... in BOL 2005? ... guess it's not a reserved word even though it gets colored blue.) ... SQL Server Documentation Team ... Why isn't SERVICE in the list of T-SQL reserved words in BOL 2005? ...
    (microsoft.public.sqlserver.tools)
Quantcast