Does SQL Server have an 'ON ERROR RESUME' type function in TSQL to match the VB facility?

A. No. All you can do is check @@ERROR after a statement has been run and do something based on that - you could do a GOTO to an error routine if it is in the same batch of TSQL.