Easy Way to Convert SQL Data to XML?

Hi to all :

Does anyone know how convert easily the SQL Records into XML?

OcinxLook into the FOR XML clause in the SQL Help files. That will return the data from the server already converted to Xml. You can also read the data into a DataSet and then call the GetXml method to convert the data in the DataSet to Xml.

Good luck.|||I have found this to be a good reference:XML and Internet Support -- Retrieving and Writing XML Data.

Terri