Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

37 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • marcscheuner commented  ·   ·  Report

    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  ·   ·  Report

    +1 XML methods may seem like a low priority, but FOR XML PATH(''), TYPE is the main solution for string concatenation in SQL Server:

    SELECT
    (
    SELECT
    p.Name
    FROM Production.Product AS p
    ORDER BY
    p.Name
    FOR XML
    PATH (''),
    TYPE
    ).value('.[1]', 'varchar(max)');

    Having SQL Prompt capitalize the .value() XML method (option to CAPS keywords on) is most annoying.

  • marcscheuner commented  ·   ·  Report

    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  ·   ·  Report

    Also, layout says there is an error in the sql if it has XML in the statement.