Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:58 AM
Points: 819, Visits: 832
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, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
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, February 06, 2014 4:15 AM
Points: 1,242, Visits: 1,546
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 5:14 AM
Points: 541, Visits: 189
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: Yesterday @ 7:19 AM
Points: 2,814, Visits: 3,851
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 905, Visits: 553
-

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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:16 AM
Points: 905, Visits: 553
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 5:14 AM
Points: 541, Visits: 189
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
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 3,297, Visits: 2,341
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
Best practices on how to ask questions
Post #1468514
Posted Friday, June 28, 2013 6:26 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:15 AM
Points: 3,681, Visits: 4,815
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