SQL Server Performance

update XML value

Discussion in 'SQL Server 2005 General Developer Questions' started by jmathewp, Oct 1, 2008.

  1. jmathewp New Member

    I have a table with one field containing XML value of the given structure. (level1)(level2)(name)Name1(/name)(Value)123(/Value)(/level2)(level2)(name)Name2(/name)(Value)345(/Value)(/level2)(level2)(name)Name3(/name)(Value)122(/Value)(/level2)(/level1)I want to update the xml field to remove an element from the xml field of each of the rows of the table. I want to remove the element (level2) which have a child element with name 'Name3'. Only some of the fields contain this element and only one element with name 'Name3' will be contained in an xml field.I have used () for denoting an xml element since this webpage is not displaying the xml node using angle brackets.

Share This Page