I'm using Microsoft SQL Server 2019 - 15.0.4236.7 (X64)
Compatibility Level is 2019 \ 150
I have a very simple query to transpose some JSON that is stored in a column:
SELECT OPENJSON ([fieldname])
FROM mytable
But I keep recieing the error:
'OPENJSON' is not a recognized built-in function name.
Do I need to enable something?
SELECT cols FROM mytable CROSS APPLY OPENJSON([fieldname]);
JSON_VALUE
orJSON_QUERY
if you want to extract a single value or object, respectively.