SQL Server Try Catch

gistfile1.txt

BEGIN TRANSACTION;

BEGIN TRY

-- sql commands here

END TRY

BEGIN CATCH
	-- Use RAISERROR inside the CATCH block to return error
	-- information about the original error that caused
	-- execution to jump to the CATCH block.
	SELECT
      ERROR_NUMBER() AS ErrorNumber
      ,ERROR_SEVERITY() AS ErrorSeverity
      ,ERROR_STATE() AS ErrorState
      ,ERROR_PROCEDURE() AS ErrorProcedure
      ,ERROR_LINE() AS ErrorLine
      ,ERROR_MESSAGE() AS ErrorMessage;

  IF @@TRANCOUNT > 0
      ROLLBACK TRANSACTION; --RollBack in case of Error
END CATCH;

IF @@TRANCOUNT > 0
    COMMIT TRANSACTION;
GO