Hi Everyone! Hi Rob!
I have been working through some of the exercises in the XML chapter and they are very very good. Thanks for all of the details, notes and comments you added, plus really easy to understand code.
I know that you can use a FOR XML to direct a query output to XML, but is there a way to setup SQL Server 2008 so the query results are in XML? For the default? I cannot figure out the steps on how to setup SQL server so the query results are in XML, and have also searched online a dozen ways to figure this out.
I can create XML output from a query using the examples but I want to actually setup SQL to do this.
Thanks for any advice you might be able to offer! This one is stumping me.
Have a great day and weekend!
Aspiring SQL ASP and VS geek, full time online student, IT Manager, former AS/400 guru :)