Parse JSON string with nested elements in SQL Server

Parse JSON string with nested elements in SQL Server
Check my blog: sqlwithmanoj.c...
Check the whole "SQL Server Basics" series here: • SQL Server Basics
#SQLwithManoj #SQLServer #MySQL #Oracle #SparkSQL #HiveSQL #DatabaseBasics
SQL blog: sqlwithmanoj.com/
LinkedIn: / manub22
Facebook: / sqlwithmanoj
Telegram: t.me/sqlwithmanoj

[@bstewart68]

This is the second time only one of your videos could explain a SQL concept in a way that I can understand it. Keep you the great work!

[@israel1919]

Namaste Manoj, Thanks a lot, I was getting mad looking for this solution.

[@taamcyat]

Excellent!

[@vishaljhaveri7565]

Ultimate method of JSON Parsing in SQL Server.

[@itsupportbyharshit6285]

This video is very help full. Thank You

[@mebsuta9352]

Thank you. Really helped my understanding of T-SQL JSON querying in my work.

[@praseelnarayan6188]

life Saver!

[@Artem1s-_-]

godlike explaination, ty!

[@shilpag4961]

well presented sir!

[@mgsrinivasan1]

After watching your video, I can select ARRAY values in plain Json file. Could you please help me below issue. In my Query Result havin some columns holding “Json file”, in that Json file contains nested tags, in one tag contains ARRAY, in that Array I need to select a value.

[@mrboloban25]

Thanks, great video and very informative. Just would like to know using this approach, how could I specify data type for OrderID, CustomerID, ProductID, UnitPrice for instance? I know maybe using the WITH clause but not sure how to applied.

[@sachinmundra]

what if the nested field is an xml column, do you have an example of that?

[@gangakeerthi3468]

It is fine with the column names specified in json file but what if there are no column names and nested one?

[@ranjitnahak44]

very informative sir, please make a video for multiple json with multiple id.

[@SQLwithManoj]

Can you plz provide an example Ranjit?

[@tyebrown4264]

Which version of SQL server is used in this demo?

[@SQLwithManoj]

SQL Server 2019 !!!