Modifying SQL XML column

Question

I have an XML column in one of my table. For example I have an Employee table with following fields:

Name (varhcar) | Address (XML)

The Address field is having values like

<Address>
<Street></Street>
<City></City>
</Address>

I have some n number of rows already in the table. Now I want to insert a new node - Country to all the rows in tha table. With default:

<Country>IND</Country>.

How can I write the query for this. I want all the existing data to be as it is with adding the country node to all the Address column XML.

To get your XML to display, you need to format it as code. I've done this for you... — David M
– David M, Commented Jun 15, 2010 at 8:49

Chinjoo · Accepted Answer · 2010-06-15 09:04:08Z

3

update Employee set Address.modify('insert  <Country>IND</Country>
 as last into (/Address)[1]')

answered Jun 15, 2010 at 9:04

Chinjoo

2,8326 gold badges30 silver badges45 bronze badges

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

Comments

Anuraj · Accepted Answer · 2010-06-15 08:59:47Z

2

Try this

SET @XMLDATA.modify(' insert <Country>IND</Country> as last into (Address[1]) ')

answered Jun 15, 2010 at 8:59

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges