Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. {
  2. "customerName":"mohan",
  3. "custId":"e35273d0-c002-11e9-8188-a1525f580dfd",
  4. "feeds":[
  5. {
  6. "feedId":"57f221d0-c310-11e9-8af7-cf1cf42fc72e",
  7. "feedName":"ccsdcdscsdc",
  8. "format":"Excel",
  9. "sources":[
  10. {
  11. "sourceId":69042417,
  12. "name":"TV 2 Livsstil"
  13. },
  14. {
  15. "sourceId":69042419,
  16. "name":"Turk Max"
  17. }
  18. ]
  19. },
  20. {
  21. "feedId":"59bbd360-c312-11e9-8af7-cf1cf42fc72e",
  22. "feedName":"dfgdfgdfgdfgsdfg",
  23. "format":"XmlTV",
  24. "sources":[
  25. {
  26. "sourceId":69042417,
  27. "name":"TV 2 Livsstil"
  28. },
  29. {
  30. "sourceId":69042419,
  31. "name":"Turk Max"
  32. }
  33. ]
  34. }
  35. ]
  36. }
  37.  
  38. UPDATE
  39. ExtractsConfiguration.dbo.Customers
  40. set
  41. configJSON = JSON_MODIFY(configJSON,'$.feeds[]',{"feedName":"ccsdcdscsdc"})
  42. where
  43. CustomerId = '9ee07040-c001-11e9-b29a-55eb3439cd7c'
  44. and json_query(configJSON,'$.feeds[].feedId'='57f221d0-c310-11e9-8af7-cf1cf42fc72e');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement