<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Michael Coles
»
XML Query
XML Query
Rate Topic
Display Mode
Topic Options
Author
Message
Mike C
Mike C
Posted Tuesday, July 29, 2008 12:14 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
Comments posted to this topic are about the item
XML Query
Post #542373
MarkusB
MarkusB
Posted Tuesday, July 29, 2008 1:19 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 4,218,
Visits: 3,875
Don't wanna be too picky but from the answer:
The “//*” XQuery path matches every element node in the XML document, so
(b)
is also incorrect.
And I thought "B" was the correct one.;)
Markus Bohse
Post #542391
Mike C
Mike C
Posted Tuesday, July 29, 2008 8:18 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
MarkusB (7/29/2008)
Don't wanna be too picky but from the answer:
The “//*” XQuery path matches every element node in the XML document, so
(b)
is also incorrect.
And I thought "B" was the correct one.;)
Yes, that's a typo on my part in the explanation :) The correct answer is (b), the explanation should have read "...so (c) is also incorrect."
Thanks!
Mike C
Post #542688
Anipaul
Anipaul
Posted Tuesday, July 29, 2008 10:16 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,787,
Visits: 1,335
Good question...
Post #542832
Miles Neale
Miles Neale
Posted Tuesday, July 29, 2008 10:52 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 9:51 AM
Points: 1,891,
Visits: 936
Very good question! Appreciate you work on this it will be valuable going forward in some of the work with xml.
Miles..
Not all gray hairs are Dinosaurs!
Post #542883
Chad Crawford
Chad Crawford
Posted Tuesday, July 29, 2008 3:34 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 2,548,
Visits: 17,356
If we win the book will it be autographed?
Chad
Post #543082
Mike C
Mike C
Posted Tuesday, July 29, 2008 7:50 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
Chad Crawford (7/29/2008)
If we win the book will it be autographed?
Chad
Ha :) Well, I believe my name is printed somewhere on it - that's just as good :)
Post #543152
Steve Eckhart
Steve Eckhart
Posted Thursday, July 31, 2008 7:48 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:27 AM
Points: 903,
Visits: 8,640
Speaking of winning the book, does SQL ServerCentral ever announce who the winners are in these contests? It'd be nice to see in the daily email.
Steve Eckhart
Post #544385
L' Eomot Inversé
L' Eomot Inversé
Posted Saturday, December 18, 2010 2:14 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:37 PM
Points: 7,087,
Visits: 7,142
Nice clear question and answer (apart from the typo in the explanation).
BUT: the more I see of this stuff the more I think the way XML was introduced into SQL Server was stark staring bonkers.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1036918
Mike C
Mike C
Posted Saturday, December 18, 2010 11:18 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:22 PM
Points: 1,276,
Visits: 1,112
Tom.Thomson (12/18/2010)
Nice clear question and answer (apart from the typo in the explanation).
BUT: the more I see of this stuff the more I think the way XML was introduced into SQL Server was stark staring bonkers.
LOL. XML has an interesting history in SQL Server. In SQL 2000 (first version with built-in XML support; very minimal XML support via OPENXML and FOR XML), the XML functionality seemed to be almost an afterthought tacked on at the last minute. In SQL 2005 XML was completely re-vamped, with significant improvements (i.e., XQuery support, FOR XML PATH), but performance (and
consistent performance
at that) is an area that still needs to be seriously addressed. SQL 2008 added a couple of minor tweaks to XML (i.e., "let" clause in FLWOR expressions), but more complete XQuery functions and operators (F&O) support has not been implemented -- which makes it very painful to port any useful XQuery code over to SQL Server. There's a *lot* of room for improvement in SQL Server XML support... Hopefully these issues will be addressed sooner rather than later...
Mike C
Post #1036947
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
