Category Archives: XML

Update a SQL table’s XML value to insert a node

Sometimes a snippet of example code is all that’s needed: update MyTable set XmlColumn.modify(‘ insert <Description>This is a description</Description> as last into (/xpath/to/parent)[1] ‘) where SomeValue = ‘whatever’

Posted in CodeMinder, Programming, SQL, XML | Leave a comment

Update a SQL table’s XML value to remove nodes

CodeMinder: to remind myself of stuff that I usually have to look up each time I do it. To delete all PersonAlternativeName nodes from XmlColumn of the People table: with xmlnamespaces( ‘http://mydomain.com/person/extension/0.1’ as px) update People set XmlColumn.modify(‘delete //px:PersonAlternateName’)

Posted in CodeMinder, Programming, SQL, XML | Leave a comment

Select multiple XML nodes out of each row in a SQL table

CodeMinder: to remind myself of stuff that I usually have to look up each time I do it. If a People table has a column named XML, and the XML column may specify multiple PersonAlternativeName entities, then to get all … Continue reading

Posted in CodeMinder, SQL, XML | Leave a comment