Adding new xml tag with a value takeen from another column

• IT researcher

  SSCertifiable

  Points: 7569

  More actions

  March 1, 2013 at 7:39 am

  #394290

  I have a table with xml column named xmlvalue.let xml value in those column are like shown below

  <z>

  <a>

  <b>1</b>

  <c>2</c>

  </a>

  <a>

  <b>4</b>

  <c>5</c>

  .

  .

  .

  so many tags similar to above

  .

  .

  </a>

  </z>

  I want to add a new node called <new>here value should betaken from another column</new> inside the <z><a> for every row in that column with <new> tag having a value which is taken from another column "abc" for that row.(column abc is not a xml column) which is in same table.How can i do it using xml query or sql query?

  Thank you