Timeline for 'OPENJSON' is not a recognized built-in function name [duplicate]
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 19, 2022 at 13:30 | history | duplicates list edited | Charlieface | duplicates list edited from Apply OPENJSON to a single column to Apply OPENJSON to a single column, How to parse JSON column to a table with TSQL | |
| Jul 19, 2022 at 13:30 | history | closed | Charlieface sql-server Users with the sql-server badge can single-handedly close sql-server questions as duplicates and reopen them as needed. | Duplicate of Apply OPENJSON to a single column | |
| Jul 19, 2022 at 13:25 | comment | added | Jeroen Mostert |
Alternatively, use JSON_VALUE or JSON_QUERY if you want to extract a single value or object, respectively.
|
|
| Jul 19, 2022 at 13:24 | comment | added | squillman |
SELECT cols FROM mytable CROSS APPLY OPENJSON([fieldname]);
|
|
| Jul 19, 2022 at 13:24 | history | edited | Thom A | CC BY-SA 4.0 |
edited title
|
| Jul 19, 2022 at 13:23 | comment | added | Sean Lange | OPENJSON is a table valued function, not a scalar function. | |
| Jul 19, 2022 at 13:21 | history | asked | Michael | CC BY-SA 4.0 |