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

Редактировал(а) Alexandr Fokin 2024/04/20 22:15
  • Alexandr Fokin
    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
    Alexandr Fokin, 2020/09/03 18:39

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