NEW T-SQL FEATURES IN SQL SERVER 2016 – XIV | JSON Support in SQL Server 2016

In this post we shall check out the new features Microsoft introduced in SQL Server 2016 | JSON Data (SQL Server)

JSON full form is JavaScript Object Notation and it is used for storing and exchanging data. It is a popular textual data format used for exchanging data in modern web and mobile applications. JSON is also used for storing unstructured data in log files or NoSQL databases like Microsoft Azure Cosmos DB.

Notes

1. In SQL Server 2016 JSON will be represented as NVARCHAR type.
2. Example of valid JSON

--
	'{
		 "name":"Pawan"
		,"MiddleName":"Kumar"
		,"Surname":"Khowal"
		,"Class":10
		,"SkillSet":["SQL","SSIS","SSRS","SSAS"]
		,"IsDatabaseDeveloper":true
	}';
--

3. SQL Server provides built-in functions and operators that let you do the following things with JSON text.

3.a Parse JSON text and read or modify values.
3.b Transform arrays of JSON objects into table format.
3.c Run any Transact-SQL query on the converted JSON objects.
3.d Format the results of Transact-SQL queries in JSON format.

JSON built-in functions

If you have JSON text that’s stored in database tables, you can use built-in functions to read or modify values in the JSON text.

Refer Microsoft LINK below for more details-

Enjoy !!! Keep Learning

Pawan Khowal 

Http://MSBISkills.com