Character Field Declaration

  • Comments posted to this topic are about the item Character Field Declaration

  • Nice question - thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

  • Easy one.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Nice one question.

    I was sincerely in doubt, but since it wasn't raining I chose the correct answer.

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

  • ashwani24 (2/10/2014)


    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

    It is an unwritten rule that unless specified otherwise, the latest general available version is assumed.

    At the moment of this question, that is SQL Server 2012.

    The question is also valid for the two previous versions, SQL Server 2008 and 2008R2, so claiming that the question is incorrect because of an almost 10-year old version seems like nitpicking to me.

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

  • Nice question

    Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • ashwani24 (2/10/2014)


    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

    +1

    Also, if in Somerset UK, the 'Raining' option is also true.

  • Stuart Davies (2/11/2014)


    Nice question

    Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

    Here in the north of England "it's already raining" would always be the correct answer πŸ˜€

    I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.

  • paul s-306273 (2/11/2014)


    ashwani24 (2/10/2014)


    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

    +1

    Also, if in Somerset UK, the 'Raining' option is also true.

    Sun is shining in Belgium 😎

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

  • Koen Verbeeck (2/11/2014)


    ashwani24 (2/10/2014)


    Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

    It is an unwritten rule that unless specified otherwise, the latest general available version is assumed.

    At the moment of this question, that is SQL Server 2012.

    The question is also valid for the two previous versions, SQL Server 2008 and 2008R2, so claiming that the question is incorrect because of an almost 10-year old version seems like nitpicking to me.

    I wonder what proportion of you are still (like us) using the "almost 10-year old version"?

    (We are doing preliminary work towards upgrading to 2012).

  • martin.whitton (2/11/2014)


    Stuart Davies (2/11/2014)


    Nice question

    Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

    Here in the north of England "it's already raining" would always be the correct answer πŸ˜€

    I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.

    +1


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • I just had to choose option 3 πŸ˜€

    Seriously, it would fail in my environment (SQL Server 2005) but work with newer versions as stated above.

  • Well, I ran the code and it started raining (in London).

    I feel I should throw my toys out of the pram and demand "my" point back as is the norm in such situations πŸ˜‰

    Fortunately I'd worked it out anyway.

  • BWFC (2/11/2014)


    martin.whitton (2/11/2014)


    Stuart Davies (2/11/2014)


    Nice question

    Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

    Here in the north of England "it's already raining" would always be the correct answer πŸ˜€

    I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.

    +1

    Surely BWFC doesn't mean Bolton Wanderers...

    Greetings from rainy Manchester!

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

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