How to import nested JSON object (JSON data file) in Microsoft SQL Server

In this lesson, I will be showing you how to import nested JSON object in Microsoft SQL Server.

JSON object is one of the most popular data format to store dataset today. Unlike Excel or CSV, that consist of rows and columns, a JSON object can contain a nested data arrays. That makes dataset importing a little bit more complicated in #SQL #Server.

▶ If you have never import a #JSON data file in SQL Server before, please watch my video how to import JSON file into SQL Server Database first.
https://youtu.be/rWW-j04cZQI

📺 How To Build A MS SQL Server SQL Query Tool Using Excel: https://youtu.be/6EK1kdHuSsU

► Buy Me a Coffee? Your support is much appreciated!
————————————————————————————-
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we’ll both get a free stock: https://join.robinhood.com/jiej6

► Support my channel so I can continue making free contents
—————————————————————————————————————
🌳 Becoming a Patreon supporter: https://www.patreon.com/JieJenn
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
🗓 Get updated on new Python videos → https://www.facebook.com/MadeInPython/
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: https://bit.ly/3B1DjSA
✉ Business Inquiring: [email protected]

#SQLServer #JSON