SQL Server - Working with JSON Part 2: Basics of OPENJSON & JSON_VALUE

Explore the basics of the OPENJSON and JSON_VALUE functions in T-SQL for SQL Server. These functions are used for reading and extracting elements from JSON data, whether it be in a column, file or variable. Scripts for the video series can be found here: https://gist.github.com/ncalm/520b5048a01b99d272406b9dcd07b59a The database being used is "AdverntureWorksDW2019", which you can get here: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms