OUTPUT - 1

  • 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]

  • the answer is ambiguous and depends from collations

    get my point back 🙂

    I Have Nine Lives You Have One Only
    THINK!

  • Really very good Question.

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

  • 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/

  • 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

  • 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

  • handkot (2/26/2013)


    the answer is ambiguous and depends from collations

    +1

    😉

  • 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.

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

  • 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.

  • This was removed by the editor as SPAM

  • 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.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • 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.

  • 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.

  • 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

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

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