JSON and SQL Tutorial - Convert a table to JSON and JSON to table

In this video I will show you how to convert JSON to a table using OPENJSON and from a table to JSON using FOR JSON PATH with t-sql. I will also cover querying specific JSON objects using JSON_VALUE as well as validating JSON using ISJSON.

[Ferruccio_Guicciardi]

Thanks for sharing the most flexible way to define the JSON tree from the dataset source !

[mahsapourshahmari]

I really like the way you say OKAY :) it makes it sound too easy to follow, like you get it? it is that simple :)

[javaguitarist]

This helped me enormously - thank you!

[cubicle_monkey]

I FINALLY got this working! Thanks for the walk through. If you had to iterate this process through multiple files, what do you think would work best?

[MrsHelepolis]

Hello james, i'm using mongo atlas sample database to train myself. i have an array in json format
"cast": [
"Charles Kayser",
"John Ott"
]
how do i transfer this array to table?

[oussamaoussama]

Pardon my out of context question: can you please upload the back propagation video for the neural networks series? Great explanation by the way.

[dannyanicamamasgo]

Thx Jame! one question, how to process when there is character special column "año" json? Like n'$."Dueño Data"

[KukuFamily]

Hi Oliver, we get json as a single row data, is it possible to have separate json row for each record?

[MrYeduguri]

Kindly explain various grid formatting options and document formatting options as well James. Thanks in advance!

[mehmetkaya]

Super!!! Thank you so much for this great tutorial

[utkarshverma]

Hi James,
Just on the same Context can we create an JSON output file from the MSSQL with suffix of DATE time<yyyymmddHHMMSS>. Can we do this?
Can we insert the data into a table of SQL so that i can import it?
How can i read a JSON file which has

[sonaligund]

could you please guide how to create json from table data in oracle 11g. It would be helpful. Thanks.

[ppp.]

do we always have to paste whole json into the code?

[paapaasare]

How would this work on data from a json API url?

[monikamalladi]

In JSON to table section using OPENJSON where can we assign the table name ?

[sachin]

How do i convert a whole column having many jsons to a table format?

[workstephens]

Anyway you can provide as downloads the original .txt and .sql files you have entered above? I try to type exactly as you have it but still get errors. Msg 102, Level 15, State 1, Line 1 - Incorrect syntax near '{'.Msg 103, Level 15, State 4, Line 2, The identifier that starts with '

[dexter]

hey chief got the following error with this "Msg 319, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon."
with your query directly from your google docs

[Imaginativeone_DF]

Will these functions work with SQLite?

[MrYeduguri]

Hi James, appreciate your efforts. Please make a video on "conditional metric embedding methods in microstrategy.