SQL Server error handling

CREATE PROCEDURE AS BEGIN SET NOCOUNT ON BEGIN TRY

  --Do work

END TRY

BEGIN CATCH /* Note that catching and rethrowing an exception is a lossy operation. ERROR_PROCEDURE() etc will be reset. */ DECLARE @errorMessage NVARCHAR(4000); DECLARE @errorSeverity INT; DECLARE @errorState INT;

  SELECT  @errorMessage   = ERROR\_MESSAGE(),
          @errorSeverity  = ERROR\_SEVERITY() ,
          @errorState     = ERROR\_STATE();

  --Perform required recovery actions.

  RAISERROR ( @errorMessage, @errorSeverity, @errorState );
  
  RETURN 1;

END CATCH

RETURN 0; END

Published: 11/09/2009

Share on Twitter