PARSENAME

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » PARSENAME

33 posts, Page 2 of 4

««1 2 3 4 »»»

PARSENAME

Rate Topic

Display Mode

Topic Options

Author

Message

mickyT

Posted Thursday, October 25, 2012 1:21 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:33 PM
Points: 299, Visits: 1,122

Thanks for the question ... also didn't know it existed

Post #1376811

Michael Riemer

Posted Thursday, October 25, 2012 2:31 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 AM
Points: 1,237, Visits: 346

Another great question to learn from - thanks. I had heard of the function, but never knew what it did.

Post #1376835

matthew.flower

Posted Thursday, October 25, 2012 2:54 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:16 AM
Points: 553, Visits: 170

A new one on me too, I would probably have ended up with really messy instr and substr or perhaps xpath functions to achieve the same.

There is an interesting example of use of PARSENAME with IP addresses which shows a practical application: http://www.sql-server-helper.com/tips/sort-ip-address.aspx

Post #1376846

DugyC

Posted Thursday, October 25, 2012 4:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:21 AM
Points: 1,162, Visits: 728

Learned something new today, not sure I'll ever need to use it, but you never know.

Thanks for the good question. BigGrin

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"

Post #1376883

Stewart "Arturius" Campbell

Posted Thursday, October 25, 2012 4:32 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 3:48 AM
Points: 3,125, Visits: 4,311

Interesting question, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1376893

(Bob Brown)

Posted Thursday, October 25, 2012 4:57 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100

Thank you for the great question. Enjoyed an easy one.

Post #1376911

Dana Medley

Posted Thursday, October 25, 2012 6:31 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:37 PM
Points: 1,350, Visits: 871

Thank you for the great question. I learned something new today and I already can think of a few applications I can use it with. Smile

Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah

Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1376951

sestell1

Posted Thursday, October 25, 2012 7:24 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 832, Visits: 1,206

Interesting question. I did run into this function once before when looking for a simple way to parse a short delimited string. Unfortunately my string had five elements. Sad

Post #1376978

mtassin

Posted Thursday, October 25, 2012 8:00 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 3,226, Visits: 64,204

Koen Verbeeck (10/25/2012)

Great question about a function I didn't even know it existed BigGrin

I knew it existed, but never had much use for it. A guy who I help with SQL problems on occasion was using it to split a manager heirarchy string I had built.

Still personally don't have much use for it. And one day I'll get him to use Jeff's Delimited8k split function I have available instead, but at least I knew what this was.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems

Post #1377002

Revenant

Posted Thursday, October 25, 2012 10:44 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 3,454, Visits: 2,529

Thanks for a nice question. BTW, reversal of the order is a frequent pitfall for people who are parsing IPs and do not read the doc carefully enough.

Post #1377128

« Prev Topic | Next Topic »

33 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions