OUTPUT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » OUTPUT - 1

42 posts, Page 2 of 5

««1 2 3 4 5 »»»

OUTPUT - 1

Rate Topic

Display Mode

Topic Options

Author

Message

Stewart "Arturius" Campbell

Posted Wednesday, February 27, 2013 1:51 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129, Visits: 4,312

Good question, Ron, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1424398

Richard Warr

Posted Wednesday, February 27, 2013 2:23 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,609, Visits: 1,103

handkot (2/26/2013)

the answer is ambiguous and depends from collations
get my point back Smile

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.

Post #1424405

call.copse

Posted Wednesday, February 27, 2013 3:26 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:48 AM
Points: 1,088, Visits: 693

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.

Post #1424433

ldorian81

Posted Wednesday, February 27, 2013 4:26 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:37 AM
Points: 275, Visits: 222

took a stab in the dark... missed totally

good question, look forward to playing with it when i finally get 2012 Tongue

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.

Post #1424460

Lokesh Vij

Posted Wednesday, February 27, 2013 4:47 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:24 AM
Points: 1,176, Visits: 1,253

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 Tongue

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

~ 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 #1424464

ldorian81

Posted Wednesday, February 27, 2013 4:49 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:37 AM
Points: 275, Visits: 222

--Using SQL Server 2008R2 or 2012

#Sarcasm

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.

Post #1424465

Thomas Abraham

Posted Wednesday, February 27, 2013 5:04 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 4:58 AM
Points: 1,152, Visits: 1,457

Thanks for the question Ron. Clever of you to have used the lower case 'w' to make the conspiracy minded believe this was yet another question on collation.

Please don't go. The drones need you. They look up to you.

Post #1424469

kapil_kk

Posted Wednesday, February 27, 2013 6:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, May 19, 2013 11:16 PM
Points: 1,061, Visits: 1,151

very nice question as doesn't know much about OUTPUT clause Smile

Post #1424488

L' Eomot Inversé

Posted Wednesday, February 27, 2013 6:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 7,112, Visits: 7,185

Raghavendra Mudugal (2/27/2013)

(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)

I agree, no need to mention the collation when it's the default collation (although some will always complain).
However, the default isn't Latin1_General_CI_AI, it's case insensitive. But it's accent sensitive - CI_AS

edit: add missing bit, so it makes sense

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #1424490

L' Eomot Inversé

Posted Wednesday, February 27, 2013 6:25 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 7,112, Visits: 7,185

Nice question, but two (very minor) niggles: (i) what was the last statement for? and (ii) why refer in the explanation to the output clause returning rows to the client when the question is actually about the output clause inserting rows into a table?

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #1424491

« Prev Topic | Next Topic »

42 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions