T-SQL Json_modify function

Question

T-Sql JSON_MODIFY function has some issue its adding wrapper when appending a new value pair like

  declare @jsonstring varchar(max) ='{"Width":"100%","Length":"45%"}'  
  select JSON_MODIFY(@jsonstring,'append $.Height ','50%' )

-- output {"Width":"100%","Length":"45%","Height":["50%"]}
-- Its adding wrapper i am unable to remove that wrapper
-- expecting output {"Width":"100%","Length":"45%","Height":"50%"}

Razvan Socol · Accepted Answer · 2019-01-16 20:38:41Z

5

Try this query:

declare @jsonstring varchar(max) ='{"Width":"100%","Length":"45%"}'  
select JSON_MODIFY(@jsonstring,'$.Height ','50%' )

The documentation for append says:

"Optional modifier that specifies that the new value should be appended to the array referenced by < json path >."

answered Jan 16, 2019 at 20:38

Razvan Socol

5,7492 gold badges22 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lukasz Szozda Over a year ago

That is it. My idea was to use JSON_MODIFY twice demo

Collectives™ on Stack Overflow

T-SQL Json_modify function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related