json-functions-transact-sql.md

title	JSON Functions (Transact-SQL)
description	Use JSON functions to validate or change JSON text, or to extract simple or complex values.
author	WilliamDAssafMSFT
ms.author	wiassaf
ms.reviewer	jovanpop, umajay, randolphwest
ms.date	07/23/2025
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
ms.custom	ignite-2025
helpviewer_keywords	JSON functions
dev_langs	TSQL
monikerRange	=azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb

JSON functions (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw-fabricsqldb]

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 [!INCLUDE ssNoVersion], see JSON data in SQL Server.

Related content

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