I have several XML in my DB that need to be updated. Here is the simplistic representation of them:\[code\]<root> <child1>blah</child1></root>\[/code\]I need to wrap \[code\]<child1>\[/code\] with another element to get structure like this:\[code\]<root> <child1Root> <child1>blah</child1> </child1Root></root>\[/code\]Appears easy but I am not T-SQL and DML specialist.Note: if one is interested in knowing why to update, the answer is that the XML below is not deserializable using DataContractSerializer. It can be deserialized using XmlSerializer and XmlArray attribute but not DCS:\[code\]<root> <child1>blah</child1> <child2>blah</child2></root>\[/code\]