Skip to content
Advertisement

Tag: open-json

Parsing JSON from SQL Server

I have a table with the following columns, one column being a JSON blob. I’m unclear how to parse the JSON blob as a series of columns alongside the other columns. I know there’s something called OPENJSON, but not sure how to apply it to this case. The json string example is below, from the DATA column above Answer openjson

Advertisement