CODEWITHSUNDEEP
sqlsql-serverxml
sesame
sesame

Reputation: 825

Modify xml element name in SQL Server

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 ?

Upvotes: 5

Views: 2654

Answers (3)

petergo
petergo

Reputation: 390

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

Upvotes: 2

Stijn Sanders
Stijn Sanders

Reputation: 36850

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

Upvotes: 1

petergo
petergo

Reputation: 390

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

Upvotes: 0

Related Questions