How to access XML file using SQL ??

• p_barkare

  Grasshopper

  Points: 15

  More actions

  August 16, 2002 at 12:10 am

  #79558

  I would like to create an xml file using SQL and then want to update that file accrding to the requirement. How can i do that?

  Thanks

  Pradip

• crosspatch

  Hall of Fame

  Points: 3168

  More actions

  August 16, 2002 at 3:13 am

  #434685

  Presuming you're using SQLServer 2000 then check out the FOR XML and OPENXML keywords.

  If you're on anything less, like say 7. then you can use ADO XML recordsets (ADO 2.6 and higher) but there are no TSQL commands available

  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961

  
  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961