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



Yukon and For Xml (Part 2)

Posted in Sql and Xml at Friday, February 20, 2004 1:26 AM Pacific Standard Time

Michael has posted part 2 of using For Xml in Yukon. He even answered my question from my previous post. I must say I'm very impressed with the new For Xml syntax. It looks like it solves a lot of problems and removes the complexity that kept so many people from using For Xml.

Michael has requested that you post questions on what you want more information about. Below are a few questions that I have:

1) Will the new nesting mode support stored procedures?

2) Would you be able to store the results of a For Xml query into a variable? And if so, can you use those results in For Xml nested queries?

3) I'm not sure I understand the value list example:

(select orderid as 'data()'
 from orders
where customers.CustomerID=orders.CustomerID
 ) as '@OrderIDs',

What does this result in? ?

4) When will we get to try these ourselves ;)

I guess if your moving on to XQuery next I will have to find a good XQuery book to get read up on the subject. The information posted so far has been great and I'm looking forward to more of it.


Comments are closed.