Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


XQuery string functions


XQuery string functions

Author
Message
Cliff Jones
Cliff Jones
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4069 Visits: 3648
I had no clue but made a lucky guess. So maybe I should buy a lottery ticket today ...
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1300 Visits: 778
thanks for the question - cheers
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5779 Visits: 4713
Nice question - thanks!
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4420 Visits: 2342
Thanks for the question! I don't think I will ever use XQuery either but it's good to research these things anyways.
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10707 Visits: 12008
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

Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4420 Visits: 2342
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 :-D Glad I am part of the majority on this thought!
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21075 Visits: 18259
Nice question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Ian_McCann
Ian_McCann
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2281
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
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10707 Visits: 12008
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

Ian_McCann
Ian_McCann
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1872 Visits: 2281
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search