Retrieve XML Dataset of SQL Server 2005 using FOR XML
Posted: Wed Nov 19, 2008 10:37 pm
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
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