RealWorldDevelopers
9/19/2016 - 11:38 PM

Handling Errors in SQL using Error Numbers

Handling Errors in SQL using Error Numbers

ErrorNumberHandle.sql
content_copyfile_download
  BEGIN  

     BEGIN    TRANSACTION  

     --code lines...  

     SET   @Error   =   @@Error  
  IF @Error   <>   0   --if error is raised  
      BEGIN  
      GOTO   LogError  
      END  

     COMMIT    TRANSACTION  
     GOTO   ProcEnd  

  LogError:  
     ROLLBACK    TRANSACTION  
 
     DECLARE   @ErrMsg varchar(1000)  
     SELECT   @ErrMsg   =   [description]   FROM   master.dbo.sysmessages  
     WHERE   error   =   @Error  

     INSERT INTO   dbo.error_log (LogDate,Source,ErrMsg,Remarks)  
     VALUES   (getdate(),   'dbo.sp_ParseMedical2Table'   ,@ErrMsg,(   'SP Failed: ArrestID# '    +    '123'   ))  
 
  ProcEnd:  
  END