How to insert a XML text() value as the value for another XML element

Question

I'm trying to insert a new XML element in my XML data type, but this new XML element must contain the value of another XML element. For example, given the following XML:

<Config>
    <SomeOtherNode>
        <ValueToUse>123</ValueToUse>
    </SomeOtherNode>
</Config>

should render the following:

<Config>
    <Node1>123</Node1>
    <SomeOtherNode>
        <ValueToUse>123</ValueToUse>
    </SomeOtherNode>
</Config>

I've attempted the following with no luck (it inserts the XQuery as the actual value):

update Table
set Column.modify('insert <Node1>//SomeOtherNode/ValueToUse/text()</Node1> as first into /Config')

Joe Wicentowski · Accepted Answer · 2016-08-29 15:29:51Z

1

XQuery uses curly braces to denote enclosed expressions, distinguishing the content expression from literal text. To fix your query, surround the enclosed expression with curly braces:

<Node1>{ //SomeOtherNode/ValueToUse/text() }</Node1>

(The whitespace inside the curly braces is just for visual clarity and isn't needed.)

The purpose of curly braces is defined in the spec at https://www.w3.org/TR/xquery-31/#doc-xquery31-EnclosedExpr:

Definition: An enclosed expression is an instance of the EnclosedExpr production, which allows an optional expression within curly braces.

EnclosedExpr       ::=      "{" Expr? "}"

Definition: In an enclosed expression, the optional expression enclosed in curly braces is called the content expression.

answered Aug 29, 2016 at 15:29

Joe Wicentowski

5,30418 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rudolf Lamprecht Over a year ago

Dude, you are a legend

Joe Wicentowski Over a year ago

Happy to help, Rudolf!

Collectives™ on Stack Overflow

How to insert a XML text() value as the value for another XML element

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related