JQmwh0pD

1collaborator (id int, data xml)
2	
3<collaborator>
4<id>5759501959199724993</id>
5<lastname>Рязанцев</lastname>
6<firstname>Дмитрий</firstname>
7<middlename>Александрович</middlename>
8<phone>499-0000000</phone>
9<email>ryazancevda@mail.ru</email>
10<login>ryazancevda@mail.ru</login>
11</collaborator>
12	
13declare @xml xml 
14select @xml=data from collaborator
15declare @email varchar(80)
16declare @login varchar(80)
17
18begin
19update collaborator
20    set @email = @xml.value('(/collaborator/email)[1]', 'varchar(80)')
21    set @email = replace(@email, 'yandex.ru', 'mail.ru')
22    set @xml.modify('
23       replace value of (/collaborator/email/text())[1]
24       with sql:variable("@email")
25   ')
26
27    set @login = @xml.value('(/collaborator/login)[1]', 'varchar(80)')
28    set @login = replace(@login, 'yandex.ru', 'mail.ru')
29    set @xml.modify('
30       replace value of (/collaborator/login/text())[1]
31       with sql:variable("@login")
32   ')
33
34 end
35select @xml;