Channel 9

Channel 9 is a community. We bring forward the people behind our products and connect them with those who use them. We think there is a great future in software and we're excited about it. We want the community to participate in the ongoing conversation. This is the heart of Channel 9. We talk about our work but listen to the customer.

https://channel9.msdn.com/

subscribe
share



 

Using JSON in SQL Server 2016 and Azure SQL Database | Data Exposed


Since Jovan was in Redmond we thought we would take advantage of his time and do another video on JSON. Building on he earlier introductory video on JSON, Jovan spends a few minutes discussing why JSON support was added to SQL Server 2016 and Azure SQL Database then spends the rest of video starting at the 4:01 mark in T-SQL showing us how to work with JSON data. Jovan provides an overview of the different JSON functions available, then proceeds to show us how to use these functions across a variety of use cases, including how to take JSON to tabular data, how to take tabular data and turn it into JSON, as well as how to edit and modify existing JSON.  


share





 30 August 2016  19m