Forum Replies Created

Viewing 15 posts - 301 through 315 (of 658 total)

  • RE: Basic Date Function

    sgmunson (3/13/2013)


    Please consider the value of the question before deciding it's a good one.

    Please consider the value of your reply before adding the thousandth identical "this question is wrong" post...

  • RE: SubQuery

    db4breakfast (3/8/2013)The question did more good than harm.

    Only for people who came to the discussion thread.

    For anyone who just read the incorrect explanation, they'll have potentially picked up a new...

  • RE: Can This Work?

    Steve Jones - SSC Editor (3/1/2013)


    I guess perceptions are different. With the comments noting

    -- first step

    ...

    -- second step

    ...

    I executed each section of code until the next comment, since that...

  • RE: Update with CASE statement

    Tony Bater (2/22/2013)the result of statement 4 will not be that objective.

    Why not?

  • RE: Basic Date Function

    sipas (2/15/2013)


    But what implies there are two boxes?

    Nothing.

    What suggests there is only one?

    Nothing.

    Either requires an assumption.

  • RE: Merge

    sknox (2/14/2013)


    it relies on behavior specifically described by Microsoft as non-deterministic, and so should be considered dangerous.

    I wonder why Microsoft allow such code to parse as valid, given that they...

  • RE: EXECUTE

    How long until the first complaint that the correct answer is None of the Above, because there's no such database as AdventureWorks2008 😉

  • RE: Basic Date Function

    john.arnott (2/13/2013)


    The only assumption, and a perfectly reasonable one, is that the computers involved are set to their current local time.

    The other assumption is that SQLServer is running on...

  • RE: Basic Date Function

    Stuart Davies (2/13/2013)


    sipas (2/13/2013)


    Question though - how do you know which is the right answer when two of the answers are the same?

    If SQLServer is running on your own...

  • RE: Basic Date Function

    Dineshbabu (2/13/2013)


    I got it correct, Not because i'm staying in India. As Hugo and others said, In the given options SYSUTCDATETIME ( ) is the only option which will return...

  • RE: Basic Date Function

    Hugo Kornelis (2/13/2013)


    Once I saw that the time portion of the result was not the same as the listed system time, there was only one option left anyway.

    That was my...

  • RE: The Lonely and Neglected Cartesian Product (Cross Join)

    archie flockhart (2/12/2013)


    The third is wrong because the requirements are that the three rows for each person are produced with a 1 on the first row, 2 on the second,...

  • RE: Creating Tables

    Koen Verbeeck (2/11/2013)


    Well, it doesn't help that no-one ever uses Integer

    I always use Integer 🙂

  • RE: Basic maths - operator precedence

    venkat9.sql (2/6/2013)


    All you need to know to answer this question is that parenthesis override any operator precedence.

    Parentheses are part of the operator precedence 😉

  • RE: Basic maths - operator precedence

    archie flockhart (2/6/2013)

    It can matter whather you do the multiply or divide first.

    (12 / 3) * 2 will give a different answer to 12 / (3*2)

    Yes, but that's covered...

Viewing 15 posts - 301 through 315 (of 658 total)