• Hugo Kornelis (9/5/2012)


    This question (the second, chronologically) basically asked which of the insert formats used would fail and which would work.

    Yes, from the previous post it has been proved that that insert data been provided here for this question also gets succeeded like the previous one.

    The other question (the first, chronologically) used these insert formats to set up sample data and than asked what the effect of a certain statement on that sample data would be. That question is completely different. The sample data could have been given in a variety of other formats without affecting the question.

    I apologize if my wording were not consistent.

    Now I see the difference here... when i say "same" i didn;t mean the objective of the both are same, i meant the question itself as there is no difference apart from the final select statement where the SELECT INTO is been removed and this question is been changed with some difference in the detail.

    So yes, they are different questions. And I think they are both good by themselves. But in combination and in the order they are published here, this (second) question is weak: the same methods of inserting were used for the first question and the rest of that question implied that they would run error-free, so anyone who looked more than casually at that question is bound to get this one right. Had the order been reversed, then both questions would have been good.

    Yes, I agree if you are focusing on the objective.

    Thank you for your reply. (it is always feels good to interact with experts, not to argue) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.