Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Query Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2008 12:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Comments posted to this topic are about the item XML Query
Post #542373
Posted Tuesday, July 29, 2008 1:19 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
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
Posted Tuesday, July 29, 2008 8:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
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
Posted Tuesday, July 29, 2008 10:16 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 4:30 AM
Points: 5,345, Visits: 1,388
Good question...


Post #542832
Posted Tuesday, July 29, 2008 10:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:04 AM
Points: 2,299, Visits: 1,356
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
Posted Tuesday, July 29, 2008 3:34 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:19 AM
Points: 2,607, Visits: 17,927
If we win the book will it be autographed?



Chad
Post #543082
Posted Tuesday, July 29, 2008 7:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
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
Posted Thursday, July 31, 2008 7:48 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 7:18 AM
Points: 993, Visits: 8,655
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
Posted Saturday, December 18, 2010 2:14 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:48 AM
Points: 8,739, Visits: 9,287
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
Post #1036918
Posted Saturday, December 18, 2010 11:18 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
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 »

Add to briefcase

Permissions Expand / Collapse