how do i trap a syntax error at runtime?

• rob mcnicol

  SSC Eights!

  Points: 834

  More actions

  August 14, 2008 at 8:41 pm

  #72788

  i have a stored procedure with the following statement:

  select cast ('MyText' as integer) as MyField

  i would like to trap the syntax error that it produces, then continue execution of other commands in the stored procedure.

  is this possible?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 14, 2008 at 9:40 pm

  #858530

  I don't think that there is a way to do this pre-2005.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question