Forum Replies Created

Viewing 15 posts - 31 through 45 (of 163 total)

  • RE: Inserting XML

    TomThomson (6/1/2016)


    What, do you think that neither an XML document nor an XML content fragment can have a single element with a single attribute? I'm pretty sure that the...

  • RE: Inserting XML

    Choose the "correct" answer by eliminating the ones that were definitely correct.

    Agree with the rest, code is working and no error occurs. A bit strange though, because according to...

  • RE: ORDER BY ASC and NULLs last

    g.maxfield (4/7/2016)


    It also works using Order by val desc which is what I selected so I got an error on the correct answer

    That is not correct what you say. The...

  • RE: Temporary Table Limitations

    Ed Wagner (4/6/2016)


    morlindk (4/6/2016)


    I have not tried it out. However,

    http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/

    ...states that partitioning is possible!?

    Hence the answer.

    How do you mean that: the answer is "A temp table...

  • RE: Temporary Table Limitations

    According to this article a temporary table can be partitioned:

    http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/.

    So "Temporary tables cannot be partitioned" is not a limitation.

  • RE: Create Procedure

    I gave the correct answer, but was doubting. The "should" triggered something in my mind to read it as "you can but it is not a good option".

    However, you can...

  • RE: More wildcard searches

    radek.hruby (10/28/2015)


    The author possibly overlooked that in the first sentence the word "coffee" is twice.

    +1

    Forgot the "coffee " in "coffee bean". Obviously the "coffee." didn't meet the selection criteria. 😀

  • RE: Finding Azure SQL Database

    This question was so simple that I started to doubt if it was a trick question.

    But no, it was that simple! 😀

  • RE: Renaming

    helenlu7 65408 (9/28/2015)


    Can you add an alien name as 'NASales' to the existing

    instance 'USSales' to achieve the same thing??

    ie users will see instance as 'Sales0\USSales', but it points to...

  • RE: Counting Classes

    I guess we are making a big thing out of something small. Steve wrote "subject" but meant "class" (as it even shows in the alias for the count field in...

  • RE: Counting Classes

    matthew.flower (9/24/2015)


    I agree; poor question with no correct answer. How can a count of rows in a table that lists Classes return a "count of subjects in each"?

    I...

  • RE: The checksum

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


    I agree this question is a sketchy, because it shows a poor programming practice with CHECKSUM. This brings to mind the problems of trying to...

  • RE: The checksum

    sknox (9/15/2015)


    But now, I think the correct answer is "Yes, Always". Here's how it works:

    1. Bobby writes this code.

    2. Bobby gets fired for using a dangerous function and using it...

  • RE: The checksum

    I agree with the others. This answer is completely wrong. It should be "No, never".

    The possibility of having collisions in fact is the reason why you never can rely on...

  • RE: Print a nvarchar variable

    Toreador (8/11/2015)


    "however, you have to append in increments with each increment less than or equal to 4000"

    Not true.

    +1

    Not sure where that assumption is coming from. Seems incorrect to me too.

Viewing 15 posts - 31 through 45 (of 163 total)