How can i do that a stored procedure ignore a Error

• rcluciano

  SSC Veteran

  Points: 284

  More actions

  April 2, 2004 at 5:25 am

  #163323

  I have a stored procedure using insert statement, this insert can cause a key duplicate error.

  How can i do that this stored procedure ignore this error?

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 2, 2004 at 6:01 am

  #501587

  Try to avoid the duplicated key.

  insert into table

  select ---- from insertTable

  where not exists(select * from table where key = insertTable.key)

• Glenn Lehman

  SSC Rookie

  Points: 39

  More actions

  April 2, 2004 at 6:13 am

  #501589

  To continue processing after an error you must turn off XACT_ABORT then check and respond to (or ignore) the error yourself.

  DECLARE @iErrorID INT

  SET XACT_ABORT OFF

  INSERT INTO TABLE

  SELECT @iErrorID = @@ERROR

  THEN use IF logic to respond to error number according to your desires.

  Additionally, you will still get error raised if you has an invalid column or table name or similar type of error.

  Glenn