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

Bug: SQL Prompt not parsing string concatenation within the OPENJSON function.

SQL Server allows for the path parameter to be constructed within OPENJSON.
Using this functionality prevents SQL Prompt to run Code Formatting/Correction on the query.

CROSS APPLY OpenJson(D.JSONColumn,'$.path.' + tableAlias.[pathColumname])

The error is a Script parsing Error: Incorrect syntax near +
alexw
0

Comments

1 comment

Sort by
  • Mac_F
    Hi Alex,

    Thank you for your question regarding SQL Prompt. We have been able to reproduce this issue, and I an escalating the matter to our senior engineers to confirm. I will let you know as soon as possible with a meaningful answer to provide.

    Kind regards,
    Mac_F
    0

Add comment

Please sign in to leave a comment.