Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
 Posted - 2007-03-05 : 00:39:28
|
I am modifying a colorizer for sql code and am looking for a complete list of the reserved keywords in t-sql. So far the most complete list I've been able to locate is this, but it's ansi, not the mssql variant:http://developer.mimer.com/validator/sql-reserved-words.tmlBOL is pretty much mute on the subject. says reserved words exist but then doesn't bother to provide a list of them:http://msdn2.microsoft.com/en-us/library/ms190011.aspxAlso I'd like to locate a list of all the system functions like getdate(), newid(), charindex(), etc. I know these are in BOL, but not in a format that's useful to me - I'd like one big copy/paste rather than going to each individual page for each system function in BOL. Is there a system table where they are all listed perhaps? That would be ideal but such a table doesn't exist to my knowledge.I'm interested in both the 2000 and 2005 lists. Don't care about 7.0 and below.ThanksJesse
www.elsasoft.org |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-05 : 00:50:54
|
| Reserved keywords are provided here:http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspxHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-05 : 02:00:26
|
excellent, thanks.if you find a list of system functions, lemme know.
www.elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-05 : 02:04:09
|
| This? http://msdn2.microsoft.com/en-us/library/aa275233(SQL.80).aspxNote the "unreserved" keywords.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
reserved keywords, system functions, etc