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 questionsLink 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
Viewing 15 posts - 1 through 15 (of 44 total)
You must be logged in to reply to this topic. Login to reply