How can we help you today? How can we help you today?

Format SQL Fails with FOR XML query

SQL Prompt 4.0.4.14 fails with an error saying:

"SQL Prompt was unable to format this script because some syntax errors were found while it was being parsed. These errors have been highlighted."

with this valid code:
SELECT (SELECT 'Test' FOR XML PATH(''), TYPE).value('.[1]','varchar(max)') AS Test
MikeyC
0

Comments

3 comments

Sort by
  • slaphead99
    Thanks and sorry about this - I will raise a bug report
    slaphead99
    0
  • MikeyC
    Will you post the SP number once it has been assigned to make it easier to get the status in the future? Thanks!
    MikeyC
    0
  • slaphead99
    This has been assigned SP-2939

    I will ask the team if there is a possibility of a quick patch fix.
    slaphead99
    0

Add comment

Please sign in to leave a comment.