Bryant Likes

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:

1. Create a new for xml query of any type (try select * from Person.Contact for xml auto, root('Persons') in the AdventureWorks sample database).
2. Run the query.
3. Notice the results look very similar to the Xml results in SQL Server 2000. However, they are underlined (that means you can click them :)
4. 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.