JSON in SQL Server

SQL Server 2016 will support JSON. JSON  (JavaScript Object Notation) is used for exchanging data in modern web and mobile applications and used for storing unstructured data in NoSQL databases like Microsoft Azure DocumentDB and MongoDB.

JSON Data  looks like

Transact SQL

SELECT name, surname
FROM emp
FOR JSON AUTO

JSON Output

[ 
   { "name": "John" },
   { "name": "Jane", "surname": "Doe" }
] 

JSON text is typically stored in varchar or nvarchar columns.

You can  Convert SQL Server data to JSON or export JSON and Convert JSON to rows and columns or import JSON.

JSON is explained  https://www.mssqltips.com/sqlservertip/4015/introducing-json-for-sql-server-2016/

JSON in SQL Server 2016: Part 1 of 4

http://blogs.technet.com/b/dataplatforminsider/archive/2016/01/05/json-in-sql-server-2016-part-1-of-4.aspx?wt.mc_id=WW_CE_DM_OO_SCL_TW