Error Handling in SQL

Declare @Error int

set @Error = @@ERROR                    

                if @Error = 0
set @Error = @@ERROR


IF @Error = 0
BEGIN
COMMIT  tran
END  
ELSE
BEGIN
ROLLBACK tran
END