Setting Json Property Value To Null Sqlhints When using json modify with null as the new value, the behavior depends on mode (see documentation). one trick is to use a combination of lax mode (to add a key) and strict mode (to set its value to null). Simply add the keyword strict in front of the json path, using the example supplied by the docs: declare @info nvarchar(100)='{"name":"john","skills":["c#","sql"]}'; set @info=json modify(@info,'strict $.name',null): print @info; returns {"name":null,"skills":["c#","sql"]} db<>fiddle here.
Setting Json Property Value To Null Sqlhints Use isnull() or coalesce() to provide default values when working with potentially null json data. consider using strict mode to get more predictable behaviour.
Json Json Null
Json Null Value Json Explained Bito
Comments are closed.