Forum Replies Created

Viewing 15 posts - 166 through 180 (of 206 total)

  • RE: Risks of NOLOCK, part 2

    One of the options is missing a checkbox

  • RE: Which gives the greatest points?

    Toreador (10/30/2015)


    The correct answer should be END TRY - the completion of the try, which scores 5 points in Union, 4 in League. The Try Conversion (TRY_CONVERT) then scores an...

  • RE: Which gives the greatest points?

    Easiest points I ever earned! Go All Blacks!

  • RE: Nulls in the FileTable

    According to your own cited source, last_access_time is NOT NULL.

    https://msdn.microsoft.com/en-us/library/gg492084.aspx

  • RE: Column aliases

    marcia.j.wilson (9/2/2015)


    Steve Jones - SSC Editor (9/2/2015)


    The sixth one should have had brackets. That's been corrected. However, I missed a few since there could be no joiner (=/AS) in there,...

  • RE: Column aliases

    Bobby Russell (9/2/2015)


    Steve,

    The "correct answer" is incorrect depending upon how you define 'different'.

    The 'correct answer' is incorrect depending upon how you define "different".

    The 'correct answer' is incorrect depending upon how...

  • RE: Column aliases

    SELECT mynum AS test

    FROM dbo.myTable AS mt;

    ...

    SELECT mynum AS test

    FROM dbo.myTable AS mt;

    Can anyone enlighten me how the first and the last differ?

  • RE: Logical File Names

    paul.knibbs (8/3/2015)


    Ah, the old "try to figure out the author's intent via mindreading" question--got to love them! I got the right answer simply by guessing correctly which typo had actually...

  • RE: Logical File Names

    Toreador (8/3/2015)


    Hardly an abject failure, he just got one word wrong.

    Though I was looking for a "none of the above" answer to "which of these queries will do this", because...

  • RE: Logical File Names

    Carlo Romagnano (8/3/2015)


    BWFC (8/3/2015)


    Not only do none of the answers appear to be correct but the the explanation does not match the options.

    The correct answer is Query 2, with the...

  • RE: Max DB Size for SQL Server Express

    kaspencer (7/24/2015)


    Leaving aside the sloppy way in which the title and the body of this question have been put together, can I make a plea for obliging question writers to...

  • RE: Max DB Size for SQL Server Express

    Sean Lange (7/24/2015)


    Wow so much complaining about skipping a word in the question. I don't recognize most of the names of those complaining. I suspect that is because they haven't...

  • RE: Max DB Size for SQL Server Express

    Richard Warr (7/24/2015)


    edwardwill (7/24/2015)


    Another terrible question. Only 16 words in the question - you could have extended it to 18 by adding "Express Edition".

    This was the question titled "Max...

  • RE: Max DB Size for SQL Server Express

    Another terrible question. Only 16 words in the question - you could have extended it to 18 by adding "Express Edition".

  • RE: Insert without a PK

    The question was wrong. My answer was most nearly correct (one row inserted, one row failed with error).

Viewing 15 posts - 166 through 180 (of 206 total)