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»»»

OUTPUT - 1 Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 9:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 5,573, Visits: 24,808
Comments posted to this topic are about the item OUTPUT - 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1424320
Posted Tuesday, February 26, 2013 9:23 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:01 PM
Points: 1,303, Visits: 466
the answer is ambiguous and depends from collations
get my point back
Post #1424322
Posted Tuesday, February 26, 2013 10:49 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
Really very good Question.



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1424336
Posted Tuesday, February 26, 2013 11:26 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:33 AM
Points: 2,616, Visits: 4,720
handkot (2/26/2013)
the answer is ambiguous and depends from collations


I agree somewhat
The answers will change if the database collation is case sensitive

But, overall a very good question.



Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1424343
Posted Tuesday, February 26, 2013 11:27 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:01 PM
Points: 13,334, Visits: 10,199
Very nice question, thanks Ron.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1424345
Posted Wednesday, February 27, 2013 12:09 AM


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
Nice Question Ron. Thanks

~ 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 #1424356
Posted Wednesday, February 27, 2013 12:51 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:50 AM
Points: 2,466, Visits: 2,343
handkot (2/26/2013)
the answer is ambiguous and depends from collations

+1
Post #1424367
Posted Wednesday, February 27, 2013 1:03 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 @ 8:50 AM
Points: 854, Visits: 1,934
Very interesting question, did not know until now... and I answered all correct with just mental work and I can feel my confidence is somewhat kicking in back..

(note : I know (and most of all know) collation is very important and each server/database/table or any object which is qualified for using collation has one by default whether or not we set it explicitly and result of the underlying task depends on it... I am not arguing that it must not be used or mentioned... but when the collation is not mentioned by the author in any qtod lets take it as the default say "Latin1_General_CI_AI"; mentioning the collation and its varied results in every qtod's reply is really... (dont know why it is bothering me...)... and i know now you all have a lot to say on this and like i said "i am not arguing here" its just the same replies to qtod.. kind of old gig now.. and I apologize if I offended anyone with this comment, it is not intentional; it is in general)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1424372
Posted Wednesday, February 27, 2013 1:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
Kingston Dhasian (2/26/2013)
handkot (2/26/2013)
the answer is ambiguous and depends from collations


I agree somewhat
The answers will change if the database collation is case sensitive

But, overall a very good question.


Well, I did see the whoops with a small w , but carried on with default collation of case insensitive .. a typo I guess

thanks for the question .


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1424376
Posted Wednesday, February 27, 2013 1:13 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 @ 8:50 AM
Points: 854, Visits: 1,934
demonfox (2/27/2013)
Kingston Dhasian (2/26/2013)
handkot (2/26/2013)
the answer is ambiguous and depends from collations


I agree somewhat
The answers will change if the database collation is case sensitive

But, overall a very good question.


Well, I did see the whoops with a small w , but carried on with default collation of case insensitive .. a typo I guess

thanks for the question .


+1


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1424379
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse