Support for XML functions
The XML data type methods are CASE-SENSITIVE - so SQL Prompt must NEVER EVER uppercase those! I have been requesting this feature for a long time. Please fix this.
We’ve released SQL Prompt 6 which includes support for XML functions.
This feature works nicely and (so far) flawlessly in the SQL Prompt EA release - great job, guys! That'll make my life a lot easier - wonderful !
Paul White commented
+1 XML methods may seem like a low priority, but FOR XML PATH(''), TYPE is the main solution for string concatenation in SQL Server:
FROM Production.Product AS p
Having SQL Prompt capitalize the .value() XML method (option to CAPS keywords on) is most annoying.
YES YES YES !! I've pestered Red Gate about this nuisance since SQL Prompt v3 - and not had any success yet :-( Sure hope feature request on UserVoice now gets more traction !!! You have my three votes !!
William Soranno commented
Also, layout says there is an error in the sql if it has XML in the statement.