Return
-
Title
OPENJSON not recognised -
Description
OPENJSON is not recognized in the editor, firstly it is shown as an error, secondly, it is impossible to format a script containing OPENJSON.For example, the script below executes correctly but it cannot be formatted in Toad.DECLARE @json nvarchar(1000) =N'[{"id":1,"user":{"name":"John"},"hobbies":[{"name": "Reading"},{"name": "Surfing"}]},{"id":2,"user":{"name":"Jane"},"hobbies":[{"name": "Programming"},{"name": "Running"}]}]'SELECTJSON_VALUE(person.value, '$.id') as Id,JSON_VALUE(person.value, '$.user.name') as PersonName,JSON_VALUE(hobbies.value, '$.name') as HobbyFROM OPENJSON (@json) as personCROSS APPLY OPENJSON(person.value, '$.hobbies') as hobbiesSELECTId, person.PersonName, HobbyFROM OPENJSON (@json)WITH(Id int '$.id',PersonName nvarchar(100) '$.user.name',Hobbies nvarchar(max) '$.hobbies' AS JSON) as personCROSS APPLY OPENJSON(Hobbies)WITH(Hobby nvarchar(100) '$.name')
Toad shows the error "Incorrect syntax":
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.