JSON Functions (Transact-SQL)
SQL Server (starting with 2016)
Azure SQL Database
Azure SQL Data Warehouse
Parallel Data Warehouse
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 SQL Server, see JSON Data (SQL Server).
See Also
Validate, Query, and Change JSON Data with Built-in Functions (SQL Server)
JSON Path Expressions (SQL Server)
JSON Data (SQL Server)