First published on MSDN on Mar 20, 2016
Here is an overview of JSON functionalities that are available in SQL server. In this 40-min video you can find the most important details about JSON functions, and some tips and tricks that you have missed from official documentations. If you didn't had time to read all details on MSDN this might be useful video. Topics that are covered are:
Video is available on Channel9:
https://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-2016-and-JSON-Support
JSON on Channel 9
Here is an overview of JSON functionalities that are available in SQL server. In this 40-min video you can find the most important details about JSON functions, and some tips and tricks that you have missed from official documentations. If you didn't had time to read all details on MSDN this might be useful video. Topics that are covered are:
- How to use JSON functions to take values from JSON
- How to use JSON_MODIFY function to updatr
- How to open JSON using OPENJSON table value function
- How to format queries are JSON using FOR JSON clause
Video is available on Channel9:
https://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-2016-and-JSON-Support
Updated Mar 23, 2019
Version 2.0
JovanPop
Microsoft
Microsoft