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 ««123»»

XQuery string functions Expand / Collapse
Author
Message
Posted Thursday, June 7, 2012 8:04 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:30 AM
Points: 3,946, Visits: 3,640
I had no clue but made a lucky guess. So maybe I should buy a lottery ticket today ...
Post #1312527
Posted Thursday, June 7, 2012 8:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
thanks for the question - cheers
Post #1312570
Posted Thursday, June 7, 2012 9:22 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 4,126, Visits: 3,427
Nice question - thanks!
Post #1312593
Posted Thursday, June 7, 2012 11:56 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 3,339, Visits: 1,994
Thanks for the question! I don't think I will ever use XQuery either but it's good to research these things anyways.
Post #1312698
Posted Thursday, June 7, 2012 1:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
Nice straightforward unambiguous question.

Of course it's about a nonstandard implementation of something designed to query the overhyped and much misused XML format, with which sensible people want as little to do as possible; but it's still an admirably clear and simple question.


Tom
Post #1312747
Posted Thursday, June 7, 2012 1:45 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 4:46 PM
Points: 3,339, Visits: 1,994
L' Eomot Inversé (6/7/2012)
Nice straightforward unambiguous question.

Of course it's about a nonstandard implementation of something designed to query the overhyped and much misused XML format, with which sensible people want as little to do as possible; but it's still an admirably clear and simple question.


+1 Glad I am part of the majority on this thought!
Post #1312757
Posted Thursday, June 7, 2012 3:48 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
Nice question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1312809
Posted Friday, June 8, 2012 1:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 7:08 AM
Points: 1,658, Visits: 2,089
L' Eomot Inversé (6/7/2012)

... with which sensible people want as little to do as possible...


Why?

I only ask because I have just implemented database trigger where DDL events are recorded as XML.
Having never worked with XML before it took me longer to write a view that read the data
and I earmarked this area as the the next subject to learn.

It's getting harder for this old dog to learn new tricks, so I would be interested to hear your reasons

Ian
Post #1312912
Posted Friday, June 8, 2012 9:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
440692 I am just a number (6/8/2012)
L' Eomot Inversé (6/7/2012)

... with which sensible people want as little to do as possible...


Why?

I only ask because I have just implemented database trigger where DDL events are recorded as XML.
Having never worked with XML before it took me longer to write a view that read the data
and I earmarked this area as the the next subject to learn.

It's getting harder for this old dog to learn new tricks, so I would be interested to hear your reasons

Ian

There's nothing wrong with XML in itself, in fact in its place it can be very useful. It's verbose, but that isn't always harmful. It can be inordinately complex (just try mapping stuff where the type system permits multiple inheritance and self reference, and type is itself a type, into XML) but generally isn't when its use is restricted to things it's good at, like being a useful step forwards from SGML. The trouble is that people insist on using it in cases where it both is too verbose to be practical and causes too much complexity because it's a bad match for the subject area. It has been so overhyped and so overused that when I come across it my first reaction is to check whether the particular use is reasnable. More often than not, it isn't and one of the first development problems is to take the XML and convert it into some datastructures that are suitable for purpose. For example XML gets used when minimising data size is an extremely desirable objective, it gets used for passing large numbers of objects all having the same type even in cases where the overhead of parsing a textual format is the limiting factor on system capability, and it gets used in many other circumstances for which it is wholely inappropriate. I probably shouldn't dislike XML for these reasons, but instead dislike the idiots who misuse it and the charlatans who promote it as the best remedy for all ills since snake oil, but I'm only human and people's misuse of (and overhyping of) XML has caused me so much pain.


Tom
Post #1313240
Posted Monday, June 11, 2012 3:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 7:08 AM
Points: 1,658, Visits: 2,089
L' Eomot Inversé (6/8/2012)
440692 I am just a number (6/8/2012)
L' Eomot Inversé (6/7/2012)

... with which sensible people want as little to do as possible...


Why?

I only ask because I have just implemented database trigger where DDL events are recorded as XML.
Having never worked with XML before it took me longer to write a view that read the data
and I earmarked this area as the the next subject to learn.

It's getting harder for this old dog to learn new tricks, so I would be interested to hear your reasons

Ian

There's nothing wrong with XML in itself, in fact in its place it can be very useful. It's verbose, but that isn't always harmful. It can be inordinately complex (just try mapping stuff where the type system permits multiple inheritance and self reference, and type is itself a type, into XML) but generally isn't when its use is restricted to things it's good at, like being a useful step forwards from SGML. The trouble is that people insist on using it in cases where it both is too verbose to be practical and causes too much complexity because it's a bad match for the subject area. It has been so overhyped and so overused that when I come across it my first reaction is to check whether the particular use is reasnable. More often than not, it isn't and one of the first development problems is to take the XML and convert it into some datastructures that are suitable for purpose. For example XML gets used when minimising data size is an extremely desirable objective, it gets used for passing large numbers of objects all having the same type even in cases where the overhead of parsing a textual format is the limiting factor on system capability, and it gets used in many other circumstances for which it is wholely inappropriate. I probably shouldn't dislike XML for these reasons, but instead dislike the idiots who misuse it and the charlatans who promote it as the best remedy for all ills since snake oil, but I'm only human and people's misuse of (and overhyping of) XML has caused me so much pain.


Thanks for the reply.

In learning I will push myslef right into the middle of these idiots missusing XML.
Fingers crossed I come out the otherside
Post #1313736
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse