SQL Server 2005 Xml - Cool feature of the day
I'm sure that there are going to be a lot of things that I find very cool about the Xml support in SQL Server 2005. But here is one for today:
- Create a new for xml query of any type (try select * from Person.Contact for xml auto, root('Persons') in the AdventureWorks sample database).
- Run the query.
- Notice the results look very similar to the Xml results in SQL Server 2000. However, they are underlined (that means you can click them :)
- Click the results and voila, a nice Xml view opens up for you to look at your Xml results. Bravo! (standing up clapping)
It's the simple things that make me happy. :)
While you're at it, you should also see this example of how explicit mode is much better now.