sql server6.5 and xml file

• btkaruna

  Mr or Mrs. 500

  Points: 506

  More actions

  July 30, 2001 at 7:14 am

  #63899

  hi,

  i am working with sql server6.5.Data gets updated continiously.For each updation i need to create xml file.could some one help me out.

  thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  July 30, 2001 at 12:15 pm

  #417326

  Any chance you could upgrade to 2000?

  If not, you can use ADO to run a query from VB/ASP/VBS and then save the query as an XML file.

  Steve Jones

  steve@dkranch.net

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 30, 2001 at 8:13 pm

  #417338

  Steve's suggestion is a good one. Plenty of reasons to upgrade to SQL2K and XML support is included.

  If that's all you need though, just remember that an XML document is nothing but a big string. Easy enough to write some code to generate XML - VBScript would give you easy access to the filesystem/textstream objects, all you need to create xml. Run as a job and call it done!

  Andy

  Andy
  Connect with me on LinkedIn