Комментарий к XML Xquery | JSON JsonPath

Редактировал(а) Alexandr Fokin 2024/04/20 22:15

Alexandr Fokin, 2020/08/06 14:02

SOAP query
xml.value('
    declare namespace s="http://schemas.xmlsoap.org/soap/envelope/";
    /s:Envelope[1]/s:Body[1]/CreateResponse[1]/CreateResult[1]/Id[1]',
'nvarchar(50)'
)

;with
xmlnamespaces(
'http://schemas.xmlsoap.org/soap/envelope/' as [SOAP]
)
select xml.value(
   '/SOAP:Envelope[1]/SOAP:Body[1]/CreateResponse[1]/CreateResult[1]/Id[1]',
   'varchar(max)'
)
Alexandr Fokin, 2020/09/03 18:39

Изменение xml документа
modify
http://www.sql-tutorial.ru/ru/book_xml_data_type_methods/page5.html

Приложения