Did this without query analyser.. and got it right, nice.

Hi wall str33t,

Nice question!

Hi Charles,

Both queries will give the same error, but the question was asking what was returned in the results, not the messages.

The first query when ran by itself will error (you get messages), and the results panel will show two result sets, the first 'abc' , the second the error result set with the error number.

The second query will have three result sets:

'abc'

'xyz'

and 0

Because as wall str33t says the second query executes fine, clears @@error, therefore no error is held in the @@error variable when selected.