'OPENJSON' is not a recognized built-in function name [duplicate]

Ask Question

Asked 1 year, 11 months ago

Modified 1 year, 11 months ago

Viewed 1k times

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?

Thom A

93.4k11 gold badges52 silver badges82 bronze badges

asked Jul 19, 2022 at 13:21

Michael

2,61711 gold badges38 silver badges77 bronze badges

2

OPENJSON is a table valued function, not a scalar function.
– Sean Lange
Commented Jul 19, 2022 at 13:23
1

SELECT cols FROM mytable CROSS APPLY OPENJSON([fieldname]);
– squillman
Commented Jul 19, 2022 at 13:24
4

Alternatively, use JSON_VALUE or JSON_QUERY if you want to extract a single value or object, respectively.
– Jeroen Mostert
Commented Jul 19, 2022 at 13:25

Add a comment |

0