How to read the values into sql server 2005

• SqlSpider...

  Ten Centuries

  Points: 1254

  More actions

  February 20, 2013 at 9:41 pm

  #147965

  hi all

  Please help me to solve this..

  '<ROOT>

  <ROW>

  <ID>200147</ID>

  <VALUE>1,10,109,76</VALUE>

  </ROW>

  </ROOT>'

  Thanks,

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  February 21, 2013 at 10:36 am

  #1590070

  Something like this ?? :

  https://www.google.com/search?q=strip+html+tags&sourceid=ie7&rls=com.microsoft:en-us:IE-Address&ie=&oe=