Export data to xml file

  • Hi! 🙂

    I have to export data from sql server 2005 to a xml file using a job..

    Anyone has any idea how to export to xml? creting a new file, append to existing file?

    Thanks in advance!

  • You want to export using a SELECT with the 'FOR XML' clause

  • Matthew Bryant,

    Thanks for your reply.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply