Rename XML Node Name in XML column SQL Server using SQL Script

Question

I have a Xml Column in a SQL Server 2012 database table called ValidationList. I have a few hundred records in this table.

I have a record like follows

<Configuration xmlns="blah">
  <CheckTest name="ValidationA">
    <TestName>NumericTest</TestName>
  </CheckTest>
</Configuration>

I need to Update all the rows and Rename the Node TestName to ValidationName, how can i do this in SQL script?

Thanks

sgeddes · Accepted Answer · 2014-11-27 01:05:17Z

3

Here's one way just using replace:

update yourtable
set yourcolumn = 
       replace(cast(yourcolumn as nvarchar(max)), 'TestName', 'ValidationName');

answered Nov 27, 2014 at 1:05

sgeddes

62.9k7 gold badges68 silver badges85 bronze badges

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

1 Answer 1