Feed Icon  


  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics


Open Source Projects



SQL Server 2005 Xml - Cool feature of the day

Posted in Sql and Xml at Wednesday, July 28, 2004 5:41 AM Pacific Daylight Time

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.


Comments are closed.