JSON functions

statements

#tsql#statements

2016 (13.x) and later versions

Azure

SQL Managed Instance

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.

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

and columns.

JSON data in SQL Server.

Validate, query, and change JSON data with built-in functions (SQL Server)

JSON Path Expressions

JSON data in SQL Server