declare @Path as nvarchar(100)
set @path = '$.path.to."sub-object"'
DECLARE @json NVARCHAR(4000) = N'{
"path": {
"to":{
"sub-object":["en-GB", "en-UK","de-AT","es-AR","sr-Cyrl"]
}
}
}';
SELECT [key], value
FROM OPENJSON(@json, @Path)
I got error:
Incorrect syntax near '@Path'.
how to declare @path that i can change it.