JSON support in SQL Server - Details, tips and tricks

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