Level: Intermediate to Advanced
Business Intelligence Architect
While still in CTP, SQL Server 2016 is introducing support for JSON. It won't be implemented as a data type like XML, however, many new functions are being introduced. These functions support selecting data into a JSON object using a PATH statement similar to the XML functionality. This session will walk through demos of the most up-to-date JSON functionality in SQL Server 2016 including creating JSON objects, querying data from JSON objects and saving JSON in SQL Server.
You will learn:
- How JSON is handled in SQL Server
- How to create JSON objects using SQL Server
- How to query JSON objects using SQL Server