| title | JSON Functions (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 07/17/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database | |
| ms.reviewer | douglasl | |
| ms.suite | sql | |
| ms.technology | t-sql | |
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| helpviewer_keywords |
|
|
| ms.assetid | ec97d451-06af-44a3-8304-305d410cfc8e | |
| author | jovanpop-msft | |
| ms.author | jovanpop | |
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]
Use the functions described on the pages in this section to validate or change JSON text or to extract simple or complex values.
| Function | Description |
|---|---|
| ISJSON | Tests whether a string contains valid JSON. |
| JSON_VALUE | Extracts a scalar value from a JSON string. |
| JSON_QUERY | Extracts an object or an array from a JSON string. |
| JSON_MODIFY | Updates the value of a property in a JSON string and returns the updated JSON string. |
For more info about the built-in support for JSON in [!INCLUDEssNoVersion], see JSON Data (SQL Server).
Validate, Query, and Change JSON Data with Built-in Functions (SQL Server)
JSON Path Expressions (SQL Server)
JSON Data (SQL Server)