I am using Json Array to store child table records as a column in parent table. Now I have a requirement to conditionally delete one of the record from json array. If it would have been a table, I could have used delete command with the condition but how can I delete a record form Json array stored as varchar(max) column in SQL Server. I have gone through below url and can see command to query and modify the data but what about delete? https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-2017
Asked
Active
Viewed 812 times
0
-
provide sample JSON and expected result – Mazhar May 30 '19 at 12:27
-
see this answer for solution https://stackoverflow.com/a/47095742/3266499 – Mazhar May 30 '19 at 12:40