Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Use the functions described in this article support querying, manipulating, and construction JSON data. Use JSON functions to validate or change JSON documents, or to extract basic or complex values.
Function | Description |
---|---|
ISJSON | Tests whether a string contains valid JSON. |
JSON_ARRAY | Constructs JSON array text from zero or more expressions. |
JSON_ARRAYAGG | Constructs a JSON array from an aggregation of SQL data or columns. |
JSON_MODIFY | Updates the value of a property in a JSON string and returns the updated JSON string. |
JSON_OBJECT | Constructs JSON object text from zero or more expressions. |
JSON_OBJECTAGG | Constructs a JSON object from an aggregation of SQL data or columns. |
JSON_PATH_EXISTS | Tests whether a specified SQL/JSON path exists in the input JSON string. |
JSON_QUERY | Extracts an object or an array from a JSON string. |
JSON_VALUE | Extracts a scalar value from a JSON string. |
OPENJSON | Parses JSON text and returns objects and properties from the JSON input as rows and columns. |
For more info about the built-in support for JSON in SQL Server, see JSON data in SQL Server.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today