-- Error-declarations --
DECLARE	@MyErrNumber int,
	@MyErrSeverity int,
	@MyErrState int,
	@MyErrLine int,
	@MyErrProcedure nvarchar(128),
	@MyErrMessage nvarchar(4000);

SET @MyErrNumber = 0
--

		BEGIN TRY
			-- execution (begin)
			-- execution (end)
		END TRY
		BEGIN CATCH
			SELECT  @MyErrNumber = ERROR_NUMBER(),
				@MyErrSeverity = ERROR_SEVERITY(),
				@MyErrState = ERROR_STATE(),
				@MyErrLine = ERROR_LINE (),
				@MyErrProcedure = ERROR_PROCEDURE(),
				@MyErrMessage = ERROR_MESSAGE()
			
			select   @MyErrNumber As ErrNumber
				,@MyErrSeverity As ErrSeverity
				,@MyErrState As ErrState
				,@MyErrLine As ErrLine
				,@MyErrProcedure As ErrProcedure
				,@MyErrMessage As ErrMessage ;

			-- close open transactions (only valid for transactions in try-block)
			IF @@TRANCOUNT > 1 
			BEGIN
				ROLLBACK TRAN
			END
                                      -- DO something with error-values here 

		END CATCH; 

update myTable set Salary = salary + 100?