sqlhints.com
JSON_MODIFY Function in Sql Server 2016
JSON_MODIFY is one of the new JSON function introduced in Sql Server 2016. This function can be used to update the value of the property in a JSON string and returns the updated JSON string. SYNTAX…