How does SQL pronounce SQL?

  • 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

  • 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

  • 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 !!!

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

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

    SELECT DIFFERENCE('Sql','sickwhale')

    πŸ˜€

    Best Regards,

    Chris BΓΌttner

  • -

    --
    Dineshbabu
    Desire to learn new things..

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

    --
    Dineshbabu
    Desire to learn new things..

  • 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.

  • 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

  • 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...

  • 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

  • nice question

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

  • 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.

  • 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 43 total)

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