Options
Bug: SQL Prompt not parsing string concatenation within the OPENJSON function.
alexw
Posts: 6 New member
in SQL Prompt
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 +
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