JSON in SQL Server 2016: Part 4 of 4

Exporting Data as JSON – FOR JSON In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause. If you are familiar with the FOR XML clause, you will easily understand FOR JSON. When you add the FOR JSON clause at… Read more

JSON in SQL Server 2016: Part 3 of 4

Transform JSON Text to Relational Table – OPENJSON 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 result. In the example above, we can specify where to locate the JSON… Read more

JSON in SQL Server 2016: Part 2 of 4

Storing JSON Data in SQL Server Since external systems format information as JSON text, JSON is also stored in SQL Server as text. You can use standard NVARCHAR columns to store JSON data. A simple table where some information stored as JSON is shown in the following example: CREATE TABLE Person ( Id int IDENTITY PRIMARY… Read more

JSON in SQL Server 2016: Part 1 of 4

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is… Read more