SQL to XML

[gabber]

Hello,

I'm starting to develop a content management system.
It should use one of the known SQL servers (MS-SQL , mySQL , Oracle). I understand that there is a way to extract data from such servers in XML format and then apply some XSL on it. can anyone please point me to links (with examples) on the subject?

[Khalid Ali]

This has to be a built in functionality of the underlying Database server.look into their documentation.

[mizwhite]

You can use FOR XML AUTO, FOR XML RAW and/or FOR XML EXPLICIT to return data from SQL as XML. You'll need to configure SQL XML support in IIS and from there, you can use XML Templates (see my article on SQLJunkies.com http://www.sqljunkies.com/HowTo/5396...3C8ECACDC.scuk). Hope this gives you a start.