New training course: Customizing SQL Prompt. Watch now.

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

alexwalexw Posts: 6 New member
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 + 
Tagged:

Answers

  • 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 Frierson | Product Support Engineer | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.