PARSENAME

  • Comments posted to this topic are about the item PARSENAME

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

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

  • Jamsheer (10/24/2012)


    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

    Eid mubara Jamsheer..

    I knew of the PARSENAME ..there is a wonderful use of this for taking out the dot separated values, although with limits..

    good question..

    thanks

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

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

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • new for me..Leant n got +1:)

  • Thanks for this question Ron. I was little confused when I saw this phrase "USING SQL SERVER 2012" 🙂

    I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012!

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Jamsheer (10/24/2012)


    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

    "Eid Mubarak" Jamsheer 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Nice question, new function for me 🙂 It might be very useful. Thx

  • Thanks for the question. I did not knew it exist.

    Iulian

  • Lokesh Vij (10/25/2012)


    I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012!

    Indeed it does.

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

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

  • 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

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

    Thanks for the good question. 😀

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 32 total)

You must be logged in to reply to this topic. Login to reply