json_modify sql server

Rasel Ahmed answered on June 17, 2022 Popularity 6/10 Helpfulness 3/10

answer json_modify sql server

json_modify sql server

Comment

/*
1. Updates the value of a property in a JSON string and returns the 
updated JSON string.
2. SON_MODIFY returns an error if expression doesn't contain valid JSON.
*/

DECLARE @info NVARCHAR(100)='{"name":"John","skills":["C#","SQL"]}'
PRINT @info -- resutl : {"name":"John","skills":["C#","SQL"]}

-- Update name  
SET @info=JSON_MODIFY(@info,'$.name','Mike')
PRINT @info -- result: {"name":"Mike","skills":["C#","SQL"]}

-- add id
SET @info=JSON_MODIFY(@info,'$.id',1)
PRINT @info -- {"name":"Mike","skills":["C#","SQL"],"id":1}

Popularity 6/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 17 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

json_modify sql server

Contents

More Related Answers

json_modify sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.