DECLARE @ErrNum INT declare @errorseverity int declare @errorstate int SET @ErrNum = 0 BEGIN TRY BEGIN TRANSACTION select 1/0 COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION SET @ErrNum =ERROR_NUMBER() set @errorseverity = error_severity() set @errorstate = error_state() RAISERROR('this is my error', @errorseverity, @errorstate) END catchOr throw (using THROW instead of RAISERROR
DECLARE @ErrNum INT declare @errorseverity int declare @errorstate int SET @ErrNum = 0 BEGIN TRY BEGIN TRANSACTION select 1/0 COMMIT TRANSACTION END TRY BEGIN CATCH ROLLBACK TRANSACTION SET @ErrNum =ERROR_NUMBER() set @errorseverity = error_severity() set @errorstate = error_state() print @errnum print @errorseverity print @errorstate; throw; END catch