Feature request: show your support for XML functions.
Is this just not being considered a big problem, or what?? It's a MAJOR annoyance for me since I do a lot of XQuery stuff in SQL Server, and keep have to fix what SQL Prompt screws up constantly..... I'm seriously considering giving up on SQL Prompt because of this and going back to SSMS intellisense....
Let me explain in more detail yet another time:
Imagine a table with an XML column called "XmlData" - when I start typing:
SELECT XmlData.value(caret is here) FROM dbo.MyTable
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 must NEVER EVER uppercase those! Please!!
Unfortunately, if I press the space in my query being written in the above sample, I'm left with:
SELECT XmlData.VALUE FROM dbo.MyTable
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!)[/code]