JSON_ARRAY constructs JSON array text from zero or more expressions. The JSON_ARRAY function uses the rules described in this FOR JSON article to convert SQL data types to JSON types in the JSON array ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

Overview Modern databases, such as PostgreSQL, natively support JSON as data values that can be queried. This capability uses JSON-specific operators, including an operator to test for key presence.

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

OPENJSON is a table-value function (TVF) that looks into JSON text, locates an array of JSON objects, iterates through the elements of the array, and for each element returns one row in the output ...

Learn about JavaScript Object Notation and JSON objects and arrays, including how and why they're used. Also, find out how JSON compares to HTML and XML.

Constructs a JSON array from an aggregation of SQL data or columns. To create a JSON object from an aggregate instead, use JSON_OBJECTAGG. Optional. The order of elements in the resulting JSON array ...

JSON_QUERY ( jsonText, path ) that parses jsonText and extracts objects or arrays on the specified JavaScript-like path (see below for some JSON path examples) These functions use JSON paths for ...