Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Tuesday 10 November 2015

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

No comments:

Post a Comment

Note: only a member of this blog may post a comment.