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
Retrieve XML Dataset of SQL Server 2005 using FOR XML
Moderator: General Moderators