JSON Functions (Transact-SQL)
2 minutes to read
In this article
THIS TOPIC APPLIES TO: 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.
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)
The feedback system for this content will be changing soon. Old comments will not be carried over. If content within a comment thread is important to you, please save a copy. For more information on the upcoming change,
we invite you to read our blog post.