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.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish