How does SQL pronounce SQL?

Question

Post reply

How does SQL pronounce SQL?

ronmoses@gmail.com

SSCarpal Tunnel

Points: 4480
More actions
June 27, 2013 at 9:46 pm

#295206

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

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

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

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: 6099 More actions · Answer 2

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 More actions · Answer 3

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

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 4

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 More actions · Answer 5

Dineshbabu

Hall of Fame

Points: 3220

June 28, 2013 at 1:37 am

#1628213

-

--
Dineshbabu
Desire to learn new things..

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 6

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 More actions · Answer 7

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: 287026 More actions · Answer 8

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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 9

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 More actions · Answer 10

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: 104210 More actions · Answer 11

nice question

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

cschlieve SSC Veteran Points: 227 More actions · Answer 12

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: 183706 More actions · Answer 13

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

BarneyL Ten Centuries Points: 1044 More actions · Answer 14

While I wouldn't trust the results without checking them by eye (or expect all cases to be found) DIFFERENCE can be used as a quick and dirty way of identifying a short list of possible duplicate records.

SELECT P1.*, P2.*

FROM People AS P1

INNER JOIN People AS P2

ON P1.Date_of_Birth = P2.Date_of_Birth

AND P1.Last_Name = P2.Last_Name

WHERE P1.Person_ID <> P2.Person_ID

AND DIFFERENCE(P1.First_Name,P2.First_Name) = 4

Fuzzy grouping through SSIS is a lot more sophisticated but the above query (or variants swapping first and last name) will give a quick idea of what you're facing very quickly.

How does SQL pronounce SQL?

Cookies on SQLServerCentral