I saw that the the CREATE TABLE and INSERT INTO #Table would conflict therfore running it as one batch (as stated in the Question) would error the whole statement regardless of the GO commands being there or not being there.

The results are the same if you run the whole query as one batch with or without the 'GO' commands.

Therfore the Answer

[Quote]

Only the 1st and 3rd statement will succeed but no rows will be returned.

[/Quote]

is wrong!

And the Correct answer should be.

[Quote]

All statements will fail.

[/Quote]

If You run the whole query as 1 Batch (as stated!)

If however, you were asked to run the three independantly in the same Query window then the right answer would be.

[Quote]

Only the 1st and 3rd statement will succeed but no rows will be returned.

[/Quote]

Poorly wrote question and needs correcting. (oh and give me the point for a correct answer :-D:-P)