Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022


 

Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL batches. This functionality allows you to store and manipulate JSON documents in the database. The JSON functions – ISJSON, JSON_VALUE, JSON_QUERY, JSON_MODIFY allows you to validate, query and modify JSON documents. The FOR JSON operator allows you to transform SQL data into a JSON string. The OPENJSON operator allows you to transform JSON string into a relational dataset. Today, we are announcing the public preview of JSON enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 CTP 2.0. This