For a structured and comprehensive overview of the JSON functions in SQL Server 2016, read the "JSON Data (SQL Server)" MSDN documentation. Also, the "JSON Support in SQL Server 2016" Redgate ...

With SQL Server 2016, you can store JSON objects in your rows ... JSON_MODIFY lets you do that. You must pass the JSON_MODIFY function the JSON object, a JSON path expression to the property you want ...