OUTPUT - 1

Question

Post reply

OUTPUT - 1

Ron McCullough

SSC Guru

Points: 63877
More actions
February 26, 2013 at 9:17 pm

#290033

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[/url]
Before posting a performance problem please read[/url]
February 27, 2013 at 1:51 am

This was removed by the editor as SPAM

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

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

handkot SSCertifiable Points: 5250 More actions · Answer 1

the answer is ambiguous and depends from collations

get my point back 🙂

I Have Nine Lives You Have One Only
THINK!

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

Really very good Question.

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 3

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/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Very nice question, thanks Ron.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Lokesh Vij SSChampion Points: 10836 More actions · Answer 5

Nice Question Ron. Thanks 🙂

~ 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

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 6

handkot (2/26/2013)
the answer is ambiguous and depends from collations

+1

😉

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

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.

demonfox SSCertifiable Points: 6289 More actions · Answer 8

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 :ermm:

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

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.

Richard Warr SSCertifiable Points: 6966 More actions · Answer 10

handkot (2/26/2013)
the answer is ambiguous and depends from collations
get my point back 🙂

Does that mean you assumed the collation was Case Sensitive? Normally, when no specific information is given, it's safe to assume the default, especially considering the context of the question.

call.copse SSCoach Points: 18050 More actions · Answer 11

I honestly had not used the OUTPUT clause before, I can see how it would be helpful, so for me it's a good question, regardless of the case sensitivity blip.

ldorian81 SSCommitted Points: 1694 More actions · Answer 12

took a stab in the dark... missed totally

good question, look forward to playing with it when i finally get 2012 :-P;-)

Regards
ld

Stoke-on-Trent
United Kingdom

If at first you don't succeed, go to the pub and drink away your current thought plan.

Lokesh Vij SSChampion Points: 10836 More actions · Answer 13

ldorian81 (2/27/2013)
took a stab in the dark... missed totally
good question, look forward to playing with it when i finally get 2012 :-P;-)

Why would you require 2012 to play with OUTPUT clause? This got introduced in 2005 🙂

~ 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