Folks, this is disappointing - since about V2 or V3, I've been trying to explain that SQL Prompt *CANNOT* capitalize the XML XQuery function names as provided by SQL Server - and it still does....
Imagine a table with an XML column called "EntryData" - when I start typing:
SELECT EntryData.value(caret is here)
then I'm *CLEARLY* trying to use one of the five XML data type methods (.exist(), .modify(), .nodes(), .query(), .value()) - see here: http://msdn.microsoft.com/en-us/library/ms190798.aspx
Those XML data type methods are **CASE-SENSITIVE* - so SQL Prompt should *NEVER* uppercase those! Please!!
Unfortunately, if I press the space in my query being written in the above sample, I'm left with:
and now my XML function is no longer valid - I have to go back and manually turn it to lowercase again.
Is it really not possible to
- detect that the column I'm operating on is of type "XML"
- the string I just typed is one of the five mentioned above (that is a complete list)
- and in this case - just do *NOT* kick in the UPPERCASING (which I like otherwise - great feature - JUST NOT HERE!)