Hello, I have a table in an SQL Server database which contains a column of datatype XML. I wonder if it is possible to update the name of a node in that table using an XPath expressions?
The XML file stored in this column looks something like this:
and I want to update the nodename "Misspelled" and set it to "Correct". Is this possible to do this with an XPath expression or what it is the best way to do this?
After the update I want the XML to look like this:
As you can see it is the name of the node that I want to replace and not the node value.
Any help is greatly appreciated.
View Complete Post