Modify XML in sql 2005

• jagat.patel

  SSC Eights!

  Points: 908

  More actions

  September 17, 2009 at 1:39 pm

  #214579

  Hi all

  I have existing XML coulmn in sql 2005 looks Like these

  2008-12-01

  2008-12-01

  41010

  41010

  2

  1

  0

  4603

  4639

  41128

  0

  1

  181

  4080

  0

  I wantes to Update it in this formate

  '

  2008-12-01

  2008-12-01

  41010

  41010

  2

  1

  0

  4603

  4639

  0

  1

  18140800

  '

  basically modify FolderFilt Node

  Thanks for your help

• Swarndeep

  SSCrazy

  Points: 2347

  More actions

  September 17, 2009 at 1:58 pm

  #1055254

  There are inbuilt XML functions to use with XML data and columns. You may find some of the useful functions and how to use it at this location:

  http://www.15seconds.com/Issue/050803.htm

  Swarndeep

  http://talksql.blogspot.com