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 Wednesday, June 06, 2012 11:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, February 21, 2014 7:54 AM
Points: 1,619, Visits: 1,233
Comments posted to this topic are about the item XQuery string functions

_________________________________
seth delconte
http://sqlkeys.com
Post #1312298
Posted Wednesday, June 06, 2012 11:45 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,175, Visits: 9,124
Nice question about something I will never ever use



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1312303
Posted Thursday, June 07, 2012 1:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 21, 2014 5:57 AM
Points: 103, Visits: 303
XQuery supports four string manipulation functions:

concat() Helps concatenate two or more strings.
contains() Helps determine whether or not a string specified as the first operand contains another string specified as the second operand. The length of the search string is limited to 4,000 Unicode characters.
substring() Helps extract portion of a string from another string known as source string.
string-length() Helps calculate the length of a string.
Post #1312336
Posted Thursday, June 07, 2012 1:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 19, 2013 10:40 PM
Points: 116, Visits: 395
Nice easy question Thanks
Post #1312338
Posted Thursday, June 07, 2012 6:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:04 AM
Points: 5,468, Visits: 23,455
Would have thought that the supporting documentation would have been

http://msdn.microsoft.com/en-us/library/ms189254

Above is, in my humble opinion a much stronger support for the correct answer.



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1312451
Posted Thursday, June 07, 2012 7:36 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:23 AM
Points: 419, Visits: 228
Answer choices were sooo much easier to read than yesterday's
Post #1312496
Posted Thursday, June 07, 2012 7:37 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: Today @ 4:15 AM
Points: 3,681, Visits: 4,815
Good question, thanks.

However, I must agree with Ron....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1312498
Posted Thursday, June 07, 2012 7:41 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: Monday, March 10, 2014 6:02 PM
Points: 3,764, Visits: 1,051
Nice and easy. Thanks, Seth. I also agree with Ron about reference documentation.

"El" Jerry.


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan
Post #1312504
Posted Thursday, June 07, 2012 7:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:28 AM
Points: 2,381, Visits: 1,007
I agree with Dalton! Also, it would be nice to have a "starts-with" function...
Post #1312505
Posted Thursday, June 07, 2012 7:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:08 PM
Points: 1,189, Visits: 2,018
Koen Verbeeck (6/6/2012)
Nice question about something I will never ever use


I didn't think I'd ever use it either (I can't stand XML), but I've actually run across it twice now. Once when trying to search ReportServer databases for certain column references, and once when poking around in the plan cache for querys performing table scans. :-/
Post #1312510
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse