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 2022 have recently announced enhancements to their JSON text processing capabilities. These enhancements enable the storage and manipulation of JSON documents within the database, providing an array of functions including ISJSON, JSON_VALUE, JSON_QUERY, and JSON_MODIFY for document validation and modification. By utilizing these JSON functions, developers can efficiently process JSON documents using T-SQL batches, bringing greater flexibility and scalability to their applications and processes.
Overall, these enhancements represent a significant step forward in the handling of JSON data, bolstering the capabilities of Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022, and equipping developers with a powerful set of tools to more easily manage and process JSON documents.
The post Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 was originally published in Azure SQL Database Devs’ Corner.
Published on:
Learn moreRelated posts
SQL 4 CDS v8 Released
SQL for CDS v8 brings with it a game-changing feature – Common Table Expression (CTE) support, along with enhanced JSON functionality. ...
Azure SQL Database Elastic Jobs preview refresh
The Azure SQL Database Elastic Jobs preview has received a significant "refresh", including several capabilities requested by customers. Among...
Developing with Azure SQL bindings and Azure SQL trigger for Azure Functions
This post sheds light on how to harness the combined power of Azure SQL bindings and triggers in Azure Functions to create event-driven scenar...
Develop with SQL on your desktop using the Azure SQL Database emulator | Azure Friday
Azure Friday brings a video tutorial on how to develop apps with SQL on your desktop using the Azure SQL Database emulator. The tutorial focus...
SQL Server > Find a specific value in column of table in the whole database using T-SQL
In this post, you'll learn how to use T-SQL to find a specific value in a column within a SQL Server database. This can come in handy when you...
How to Identify SQL Server Database Server Name / Instance Name | SQL Tutorial for Beginners (15/20)
Learn how to identify SQL server database server name and instance name with this SQL tutorial for beginners. This video is part of a series t...
Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database
Azure SQL Database users, rejoice! Change data capture (CDC) is now generally available on the platform, offering you insight into your user t...
Azure SQL Database Ledger
In this special episode, Pieter Vanhove joins Sarah and Michael to provide insights into the latest feature of Azure SQL Database Ledger. This...
Azure SQL Managed Instance Windows Authentication
In this episode, Michael discusses the preview feature of Windows authentication support for Azure SQL Managed Instance with Sravani Saluru, a...