SQL Arithmetic overflow error converting expression to data type bigint

Asked Dec 01 '16 at 06:06

Active Dec 01 '16 at 06:09

Viewed 183 times

I am trying to insert a number in sql table but I am stuck with this error. It would be great if anyone can help solve this

I created a table

CREATE TABLE BulkInsert
(
e bigint ,
N bigint
)

INSERT INTO BulkInsert
VALUES (11088915669531756490937241533141381079, 4);

But when I insert values in his table i get this error:

Arithmetic overflow error converting expression to data type bigint.

edited Dec 01 '16 at 06:09

TheGameiswar

asked Dec 01 '16 at 06:06

Ara

3

Which database are you using? – Tim Biegeleisen Dec 01 '16 at 06:09
check this :http://dba.stackexchange.com/questions/51536/datatype-bigger-than-bigint – TheGameiswar Dec 01 '16 at 06:09
1

The value **11088915669531756490937241533141381079** is greater than the maximum value allowed in bigint **2^63-1 (9,223,372,036,854,775,807)**. – Dhwani Dec 01 '16 at 06:10
Possible duplicate: http://stackoverflow.com/questions/20674058/sql-server-arithmetic-overflow-error-converting-expression-to-data-type-bigint – Martin S Dec 01 '16 at 06:10
that issue was solved.. thank you so much. I used float in place of big int colum type – Ara Dec 04 '16 at 04:46

0 Answers0