JSON Archives - Page 2 of 2 - SQL Authority with Pinal Dave

SQL SERVER – 2016 – Opening JSON with OPENJSON()

December 4, 2015

The first blog I wrote about JSON with SQL Server 2016 was to get a valid JSON output from relational tables. You can read that again from: SQL SERVER – Getting started and creating JSON using SQL Server 2016. In this blog, we will try to get to the next…

SQL SERVER – Getting Started and Creating JSON Using SQL Server 2016 – JavaScript Object Notation

June 29, 2015

Pinal Dave

SQL Tips and Tricks

JSON, SQL Scripts, SQL Server

With SQL Server 2016 CTP out, I know many have started to play around with it and exploring some of the new capabilities. One of the new capabilities that has caught my attention is the introduction of JSON support. In this blog, we will get started in creating a JSON document using our SQL Server instance. Let me first introduce what JSON (JavaScript Object Notation) is and then we will move on.