Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

How does SQL pronounce SQL? Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 9:46 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, May 25, 2016 11:36 AM
Points: 1,045, Visits: 996
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
Post #1468419
Posted Thursday, June 27, 2013 9:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, May 11, 2016 7:35 AM
Points: 1,378, Visits: 1,579
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
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1468420
Posted Thursday, June 27, 2013 11:30 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 23, 2015 2:40 AM
Points: 1,242, Visits: 1,549
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 !!!
www.GrowWithSql.com

Post #1468433
Posted Thursday, June 27, 2013 11:30 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 5, 2016 5:24 AM
Points: 644, Visits: 234
Very Interesting question.. Thanks Ron.. Helped to walk through SOUNDEX and DIFFERENCE..
Post #1468434
Posted Friday, June 28, 2013 12:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 1, 2015 6:09 AM
Points: 2,891, Visits: 3,889
Love the question :) Didn't know I was working with a sick whale:

SELECT DIFFERENCE('Sql','sickwhale')


Best Regards,
Chris Büttner
Post #1468442
Posted Friday, June 28, 2013 1:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 5, 2015 4:29 AM
Points: 1,028, Visits: 569
-

--
Dineshbabu
Desire to learn new things..
Post #1468450
Posted Friday, June 28, 2013 1:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 5, 2015 4:29 AM
Points: 1,028, Visits: 569
Good question, Learned two new functions. But i don't know where can I use it.

--
Dineshbabu
Desire to learn new things..
Post #1468451
Posted Friday, June 28, 2013 5:05 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 5, 2016 5:24 AM
Points: 644, Visits: 234
Dineshbabu (6/28/2013)
Good question, Learned two new functions. But i don't know where can I use it.




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



By Running the above query, It can be understood one of the purpose.
Post #1468496
Posted Friday, June 28, 2013 5:50 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, May 27, 2016 8:42 PM
Points: 8,834, Visits: 8,079
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
Post #1468514
Posted Friday, June 28, 2013 6:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:28 PM
Points: 5,074, Visits: 6,796
Haven't used soundex since i worked in the mainframe, many years ago.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1468525
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse