SQL To XML

[glebreck]

I am not a newbie to SQL but I am definatley not an expert either. So I need some help.

I use things like Flash or Firworks which allow data connections to xml files or webservices. Webservices are out so that leaves XML. Problem is all my data is on a MSSQL server and I want it to stay there. I don't need all the data in in xml but for cetain interfaces I need to get specific data from and XML file. So what I need to know is, IS there a way to have and XML file located in my website that is updated by the SQL server everytime it is updated, added to, or something is deleted from a table?

If this is to vague I will give all the details you need.

 

[TheBugSlayer]

In SQL Books Online (BOL), lookup XML and read up on it. You can execute SQL statements using HTTP or XML templates for the same purpose, both can use XPath queries. It's a lot of reading. Although I have ran the examples I am not really an expert on that.

Good luck.