Forum Replies Created

Viewing 15 posts - 181 through 195 (of 223 total)

  • RE: CROSS APPLY on named sets

    Eirikur Eiriksson (1/12/2016)


    SQLRNNR (1/12/2016)


    I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a bit of a...

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

Viewing 15 posts - 181 through 195 (of 223 total)