How does SQL pronounce SQL?

  • ronmoses@gmail.com

    SSCarpal Tunnel

    Points: 4480

    Comments posted to this topic are about the item How does SQL pronounce SQL?

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • Lokesh Vij

    SSChampion

    Points: 10836

    Thanks for the Question Ron! I never used DIFFERENCE function earlier. Got to learn something today πŸ™‚

    ~ 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

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Lokesh Vij (6/27/2013)


    Thanks for the Question Ron! I never used DIFFERENCE function earlier. Got to learn something today πŸ™‚

    +1 πŸ™‚

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Jamsheer

    Ten Centuries

    Points: 1136

    Very Interesting question.. Thanks Ron.. Helped to walk through SOUNDEX and DIFFERENCE..

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    Love the question πŸ™‚ Didn't know I was working with a sick whale:

    SELECT DIFFERENCE('Sql','sickwhale')

    πŸ˜€

    Best Regards,

    Chris BΓΌttner

  • Dineshbabu

    Hall of Fame

    Points: 3220

    -

    --
    Dineshbabu
    Desire to learn new things..

  • Dineshbabu

    Hall of Fame

    Points: 3220

    Good question, Learned two new functions. But i don't know where can I use it.

    --
    Dineshbabu
    Desire to learn new things..

  • Jamsheer

    Ten Centuries

    Points: 1136

    Dineshbabu (6/28/2013)


    Good question, Learned two new functions. But i don't know where can I use it.

    [Code="sql"]

    declare @Nations table(Name varchar(20))

    insert into @Nations Values

    ('Sri Lanka'),('Sree Lanka'),('Sri Lanka'),('Sri Langa'),('Sree Langa')

    select * from @Nations

    select Soundex(Name) from @Nations

    update @Nations set Name = 'Sri Lanka'

    Where Soundex(Name) = Soundex('Sri Lanka')

    select * from @Nations

    [/code]

    By Running the above query, It can be understood one of the purpose.

  • Ed Wagner

    SSC Guru

    Points: 286982

    I admit I've never used the SOUNDEX or DIFFERENCE functions before, so I got to learn something today. That's always a good way to start the day. Thanks for the interesting question to end the week.

  • This was removed by the editor as SPAM

  • Rich Weissler

    Hall of Fame

    Points: 3235

    Christian Buettner-167247 (6/28/2013)


    Love the question πŸ™‚ Didn't know I was working with a sick whale:

    SELECT DIFFERENCE('Sql','sickwhale')

    πŸ˜€

    omg. This made my day! Thank you. When I get home tonight, I'm letting my kids know that I became a marine biologist. I'll let them decide whether that's a promotion or lateral move...

  • ronmoses@gmail.com

    SSCarpal Tunnel

    Points: 4480

    It doesn't strike me as a particularly useful function, especially given these examples:

    SELECT SOUNDEX('cent') --C530

    SELECT SOUNDEX('scent') --S253

    SELECT DIFFERENCE('cent','scent') --2, a very weak match

    SELECT SOUNDEX('through') --T620

    SELECT SOUNDEX('threw') --T600

    SELECT DIFFERENCE('through','threw') --3, a fair match

    --an attempt at regional diplomacy?

    SELECT SOUNDEX('route') --R300

    SELECT SOUNDEX('root') --R300

    SELECT SOUNDEX('rout') --R300

    SELECT DIFFERENCE('root','rout') --4, a perfect match

    SELECT DIFFERENCE('root','route') --4, a perfect match

    SELECT DIFFERENCE('rout','route') --4, a perfect match

    --let's see if the US and Canada can put this to rest once and for all:

    SELECT SOUNDEX('about') --A130

    SELECT SOUNDEX('aboot') --A130

    SELECT SOUNDEX('abowt') --A130

    SELECT SOUNDEX('abeet') --A130

    --all of these will DIFFERENCE with a result of 4, of course

    So that seems pretty useless.

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • george sibbald

    SSC Guru

    Points: 104200

    nice question

    ---------------------------------------------------------------------

  • cschlieve

    SSC Veteran

    Points: 217

    Got mixed up in my order on the answer. Love the question. Seems like something I would never get to use but I could see a time and place in the future (moving into education database) that I might be able to get a couple of uses out of this.

  • Luis Cazares

    SSC Guru

    Points: 183633

    ronmoses (6/28/2013)


    It doesn't strike me as a particularly useful function, especially given these examples:

    ...

    So that seems pretty useless.

    ron

    +1

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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