SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION IntFunc()
RETURNS INT
AS
BEGIN
  RETURN 922337203685477580
END
CREATE FUNCTION BigIntFunc()
RETURNS BIGINT
AS
BEGIN
  RETURN 922337203685477580
END
SELECT dbo.BigIntFunc();


(No column name)


922337203685477580


SELECT dbo.IntFunc();
Msg 8115 Level 16 State 2 Line 1
Arithmetic overflow error converting expression to data type int.