Getting error " Incorrect syntax near 'json'. Expected string variable “ (4370081)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error " Incorrect syntax near 'json'. Expected string variable “
Description

The formatter fails to format queries like the ones before:

WITH src AS (SELECT 1 id, '["Foo","Bar"]' json)
SELECT id, value
FROM src CROSS APPLY OPENJSON (json)
Cause

Formatter issue: SqlServer: OPENJSON() should accept an identifier as argument
Resolution

WORKAROUND
None
STATUS
Issue fixed . The latest version of Toad for SQL Server can be downloaded here .
Defect ID

QP-4052

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title