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: Friday, July 18, 2014 6:18 AM
Points: 846, Visits: 849
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: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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 6, 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: Yesterday @ 4:06 AM
Points: 579, Visits: 210
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, July 22, 2014 1:45 AM
Points: 2,826, Visits: 3,866
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: Thursday, June 5, 2014 8:36 AM
Points: 926, Visits: 556
-

--
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: Thursday, June 5, 2014 8:36 AM
Points: 926, Visits: 556
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: Yesterday @ 4:06 AM
Points: 579, Visits: 210
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: Friday, July 18, 2014 2:05 PM
Points: 3,943, Visits: 2,957
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


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: Yesterday @ 5:47 AM
Points: 3,855, Visits: 4,994
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