JSON Functions are introduced to SQL Server in version 2016. Saving JSON documents and retrieving documents using JSON Functions brings many possibilities to SQL Server. It is great to see that Microsoft continues to add different functions to the original JSON functions set.
Today, I will explain two new JSON functions which are available in SQL Server 2022 and Azure SQL Database.
Read on to learn more about these functions.