Retrieve XML Dataset of SQL Server 2005 using FOR XML

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
gravesee
Forum Newbie
Posts: 1
Joined: Wed Nov 19, 2008 9:18 pm

Retrieve XML Dataset of SQL Server 2005 using FOR XML

Post 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
Post Reply