• L' Eomot Inversé (4/19/2013)


    Raghavendra Mudugal (4/19/2013)


    Good one; thank you for posting.

    (the word "attempt" confused me and I executed one after the other insert statement and as I imagined, it must returned 3, and I was more confused when it pointed as wrong and all the focus was taken by "go"; it would have been great if mentioned "execute the whole as a batch"... might have give more strength to the question)

    "execute the whole as a batch" would be explicitly telling people to remove the batch terminators - ie the go statements - so that the whole could be a batch instead of several batches.

    OH "the sql comments without the word - attempt"

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