79355140

Date: 2025-01-14 13:30:18
Score: 0.5
Natty:
Report link

Using the example from How to update insert JSON property in an array of object with T-SQL I applied your scenario:

SELECT @json = JSON_MODIFY(@json, CONCAT('$.Options[', [key], '].IsDeleted'), 'false')
FROM OPENJSON(@json, '$.Options')
Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: Bart McEndree