May 19, 2010 · Is it possible to parse JSON in TSQL? I don't mean to create a JSON string; rather, I want to parse a JSON string passed in as a parameter.

Jul 24, 2025 · 6 My table in SQL Server with an nvarchar(max) column holds multiple JSON arrays in each cell. I am trying to parse the 'result' items into separate rows. JSON array:

14 I have a JSON string stored in a SQL Server table column. The column is named MSSG_RECIPS and contains one long text string like:

May 13, 2021 · To parse data in a SQL Server database from an API that returns the data in the following format:

I am currently able to parse most of a JSON file using SQL Server's OPENJSON WITH (... syntax. However, this particular file contains nested arrays which I do not know how to handle.

Jul 22, 2019 · I'm trying to parse a specific, valid JSON string from a column to its individual values using T-SQL. I have looked at many of the samples, particularly this one Parse JSON in TSQL and …

Sep 2, 2012 · Almost dup of Parse JSON in TSQL, which asks with a parameter as a source instead of a column, but have good answers and now mention the native JSON support in SQL Server 2016.

Aug 28, 2024 · 3 Since the nested JSON is stored as a string in the outer JSON, the contained values cannot be accessed directly by parsing the Invoices column. Instead, you should add a '$.Lines' …

I am using SQL Server 2012.I have been assigned a task where one of my column (JsonText) of table Sample contains json data. I want to pass parse that data and insert into columns of another table ...

Mar 12, 2019 · I am trying to parse JSON data from a table in SQL Server 2017. I have a view that returns this data: