August 11, 2011 at 6:21 am
Our company works on the model of batches (unrelated to data operations) and so I thought it was logical to name the table "Batches"... but seeing it turn blue (which indicates it is a keyword, right?) goes against my naming principles. However when I tried to look up how the keyword Batches is used I could not find a single example in documentation. It shows up as a topic (i.e. batching statements) but I can't see how it would potentially be used in TSql or any other related technology (XML, ODBC, etc.).
Anyone use this keyword?
August 11, 2011 at 7:53 am
It is not on the Reserved word list from Microsoft. Not sure why that one visually looks like a keyword.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 11, 2011 at 9:23 am
It doesn't turn blue in 2k5... if it can help.
August 11, 2011 at 9:27 am
So that's two votes in favor of my not being crazy... I'm feeling saner by the minute 🙂
August 11, 2011 at 9:35 am
It does turn blue on my 2k8 R2 express machine.
Like you said BOL is quite useless here!
August 11, 2011 at 9:36 am
2K8 is turns blue, but works fine. Not sure why. "Batch" isn't blue.
My guess is it's a mistake in the config for SSMS. I'll ask around.
August 11, 2011 at 9:38 am
That makes sense -- I wasn't thinking of that. I know that there were some omissions in the Visual Studio config files for the xml documentation definitions so it does happen occassionally with MS full release versions.
August 11, 2011 at 10:05 am
Robert Davis, head of the SQL Server MCM program, says it's a keyword, just not reserved.
August 11, 2011 at 10:07 am
Steve Jones - SSC Editor (8/11/2011)
Robert Davis, head of the SQL Server MCM program, says it's a keyword, just not reserved.
What's the difference?
August 11, 2011 at 10:09 am
Anticipated it will become part of the language at some point.
August 11, 2011 at 10:12 am
Steve Jones - SSC Editor (8/11/2011)
Anticipated it will become part of the language at some point.
Now that sounds like an answer! Thanks to all for the help.
August 11, 2011 at 10:13 am
Steve Jones - SSC Editor (8/11/2011)
Anticipated it will become part of the language at some point.
Do you know how far ahead they plan for this?
That must take a heck of a lot of planning to do this!
August 11, 2011 at 10:15 am
No, I assume they look at ANSI standards and anticipate where the language might evolve.
It's not planned, they are guessing that certain words might be used later. There are always words added over time that were not anticipated as well.
August 11, 2011 at 10:16 am
Makes sense, how many total words reserved?
August 11, 2011 at 10:16 am
ebouras (8/11/2011)
Steve Jones - SSC Editor (8/11/2011)
Anticipated it will become part of the language at some point.Now that sounds like an answer! Thanks to all for the help.
Does anyone have the Denali CTP3 to see if it has appeared there yet?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply