>Not really.
>value in @@Error changes after the execution of each statement. So if the first statement returned and error, and the last one returned ok, then @@error is ok. So after each statement you need to check @@error and copy its value into your own var.

Now you known because i doesn't suggest this.
On SQL 2005 TRY/CATCH fixes this