Page 1 of 1

Retrieve XML Dataset of SQL Server 2005 using FOR XML

Posted: Wed Nov 19, 2008 10:37 pm
by gravesee
Good day,

I created a query using FOR XML EXPLICIT to create an XML file of my entire database. Does anyone know how to access the XML dataset? When I view the results of the query in the DB analyzer it looks like the entire XML dataset is in one cell of one row. However, when I access these results in PHP I only get the lowest level of the XML file. I appreciate any help.

Thanks