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.