Even better than Query Analyzer's output is a utility that I wrote to allow experimentation with For XML queries...
as Appendix C of the book SQL Server 2000 XML Distilled. The code is in the book's download. The original version of the utility is in Visual Basic 6. I've also written a C# version of the utility, which is available on my Web site.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on XML in SQL Server
Related Q&A from Andrew Novick
Can't decide whether to use nullable fields in a table. Development expert Andrew Novick discusses what to do.continue reading
If you've had trouble connecting Visual Basic to SQL Server, let expert Andrew Novick offer some basic advice to get you started.continue reading
Development expert Andrew Novick gives you the resources to improve your stored procedure writing skills.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.