· 7 years ago · Nov 05, 2018, 11:22 AM
1DECLARE @oldvalue Varchar(255) = 'yandex.ru'
2DECLARE @newvalue Varchar(255) = 'mail.ru'
3
4UPDATE collaborator
5SET data.modify('
6 replace value of(/collaborator/email[text()=sql:variable("@OldValue")]/text())[1] with sql:variable("@NewValue")')
7where
8data.exist('/collaborator[org_name="УГЗ-"]')=1