T-SQL Error Handling - SQL Snipplr Social Repository

Revision: 52508

at October 25, 2011 11:11 by amos24c

Updated Code

BEGIN TRY
BEGIN TRAN


COMMIT TRAN
END TRY

BEGIN CATCH
  Declare @ErrorMessage varchar(2000) = (select ERROR_MESSAGE())
  Declare @ErrorSeverity int = (select ERROR_SEVERITY())
  Declare @ErrorState int = (select ERROR_STATE())
  ROLLBACK TRANSATION
  RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState)

END CATCH

Revision: 52507

at October 25, 2011 11:10 by amos24c

Initial Code

BEGIN TRAN
BEGIN TRY

COMMIT TRAN
END TRY

BEGIN CATCH
  Declare @ErrorMessage varchar(2000) = (select ERROR_MESSAGE())
  Declare @ErrorSeverity int = (select ERROR_SEVERITY())
  Declare @ErrorState int = (select ERROR_STATE())
  ROLLBACK TRANSATION
  RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState)

END CATCH

Initial URL

Initial Description

Boiler Plate for T-Sql Error handling

Initial Title

T-SQL Error Handling

Initial Tags

error

Initial Language

SQL

Choose a language for easy browsing: