Parse JSON string with nested elements in SQL Server

Parse JSON string with nested elements in SQL Server

#SQLwithManoj #SQLServer #MySQL #Oracle #SparkSQL #HiveSQL #DatabaseBasics

[bstewart]

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!

[vishaljhaveri]

Ultimate method of JSON Parsing in SQL Server.

[israel]

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

[mebsuta]

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

[itsupportbyharshit]

This video is very help full. Thank You

[mrboloban]

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.

[gangakeerthi]

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

[mgsrinivasan]

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.

[sachinmundra]

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

[ranjitnahak]

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

[tyebrown]

Which version of SQL server is used in this demo?