title: Modify JSON properties with T-SQL in SQL Server 2016
body: <p>Lets say I have JSON data :</p>
  
  <pre><code>DECLARE @json NVARCHAR(4000)
  SET @json = 
  N'{
      "info":{  
        "type":1,
  
        "address":{  
          "town":"Bristol",
          "county":"Avon",
          "country":"England"
        },
        "tags":["Sport", "Water polo"]
     },
     "type":"Basic"
  }'
  </code></pre>
  
  <p>Is there any standard way to manipulate JSON properties in SQL Server 2016 T-SQL (add new, rename, remove), something similar to what JObject offers?</p>