Untitled

Ignore Arithmetic Overflow in microsoft sql server
SELECT CONVERT(bigint, 0x8000000000000000)-1

Arithmetic overflow error converting expression to data type bigint.

SET ARITHABORT OFF;
SET ARITHIGNORE ON;
SET ANSI_WARNINGS OFF;

SELECT ISNULL(CONVERT(bigint, 0x8000000000000000)-1, 9223372036854775807)

select CONVERT(bigint, 0x8000000000000000)-CONVERT(bigint, -1)
-9223372036854775807

select CONVERT(bigint, 0x7FFFFFFFFFFFFFFF)
9223372036854775807