How can i append data to existing xml value in sql server 2008

Question

I have a table called student.

Table Student( Name varchar() ,subject xml)

I have some values in my data database. Now i have a requirement to append the xml data.

<subject code="Maths">
  <subjectname name="test">test123</subjectname>
</subject>

i want to add a new value to the existing xml.

<subjectname name="newtest">newtest123</subjectname>

this will be the sample value. Any one have any idea or way to approach the problem any work around on the same.

Dird · Accepted Answer · 2013-04-23 12:04:24Z

1

update Student set subject.modify('insert <subjectname name="newtest">newtest123</subjectname> as last into /Maths[1]') where name='YourName';

Dird

answered Apr 23, 2013 at 11:57

Dird

3352 gold badges3 silver badges12 bronze badges

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

1 Answer 1