Modify xml element name in SQL Server

Question

I want to change element name with following statement:

SET @myDoc.modify('replace value of (/CustomerInfo)[1] with "Customer"')

from
<CustomerInfo>
<ID>1</ID>
</CustomerInfo>
to
<Customer>
<ID>1</ID>
</Customer>
But failed. So how can i change it just in sql ?

petergo · Accepted Answer · 2009-05-27 04:42:53Z

2

+100

I tried following sql:
select @myDoc=(
select @myDoc.query('/CustomerInfo/node()')
for xml raw('Customer'),type)
I guess it solve your question.

answered May 27, 2009 at 4:42

petergo

3901 gold badge2 silver badges7 bronze badges

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

Comments

Stijn Sanders · Accepted Answer · 2009-05-25 16:16:02Z

1

I think you need to select the values with .query or .nodes into a resultset that will render into the XML you want using FOR XML

answered May 25, 2009 at 16:16

Stijn Sanders

37k11 gold badges48 silver badges71 bronze badges

petergo · Accepted Answer · 2009-05-20 05:22:21Z

0

I have a non-grace method:
Convert xml to varchar, then replace it.

answered May 20, 2009 at 5:22

petergo

3901 gold badge2 silver badges7 bronze badges