Reading ID from XML file???

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 13, 2006 at 2:44 am

  #68729

  Hello friends...

  We have sql server 2000 and i need to read one perticular xml and from that i want ID field stored in one table...is it possible by query analyzer to read xml and stored ID in table...I have only path of that xml file...

   

  like

   

  select ID from ("D:\XMLFolder\*.xml)

   

  that i want

   

   

   

  ---

  Regards,

  Papillon

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  July 13, 2006 at 9:43 am

  #649013

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69030

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.