返回
-
标题
Getting error " Incorrect syntax near 'json'. Expected string variable “ -
说明
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)
-
原因
Formatter issue: SqlServer: OPENJSON() should accept an identifier as argument -
解决办法
WORKAROUND
None
STATUS
Issue fixed . The latest version of Toad for SQL Server can be downloaded here .
-
缺陷ID
QP-4052