Re: Syntax coloring: SERVICE

You might want to cancel that. SERVICE isn't a keyword (*) and it is SSMS
that has it the wrong way.

Thanks Tibor. My follow-up investigation arrived at the same conclusion :>)

--
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
"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in
message news:%23sIvrul$GHA.3536@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... guess it's not a reserved word even though it gets colored blue.) ... I don't know, perhaps a keyword can work as an un-qualified identifier, while others can't. ... In the most recent update to BOL, the index returns the following choices when SERVICE is the keyword. ... service See services [Reporting Services] ...
    (microsoft.public.sqlserver.tools)
  • Re: More help with Contains
    ... You're welcome, Sanjay, ... DECLARE @keyword varchar ... SQL Server 7 does not allow UDF's!!!!! ... >> Select IdentityInd, ColA, ColB ...
    (microsoft.public.sqlserver.programming)
  • Re: Full Text Index Issue
    ... a defrag won't help. ... Looking for a SQL Server replication book? ... > The stored proc works fine except that for specific keywords the client ... > keyword being the the document name and summary. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Order
    ... Id uniqueidentifier rowguidcol not null ... constraint DF_Role_Id default ), ... Just as a keyword index would be of little use if the keywords were just ... But when yous cript out the table, SQL Server will explicitly add the ...
    (microsoft.public.sqlserver.programming)
  • Re: Need an option setting
    ... "promised" to not introduce any keywords that ends with an underscore. ... Tibor Karaszi, SQL Server MVP ... When I try to run the query ... >> Incorrect syntax near the keyword 'user'. ...
    (microsoft.public.sqlserver.programming)
Quantcast