Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.

 

ERROR MESAGGE:

“Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.”

EXPLANATION:

You may experience this error when you try to insert a row into a table that contains a column that has the IDENTITY property, and the data type is smallint.

The upper limit of the smallint data type is 32,767. (costs 2 Bytes) You cannot add more records after reaching this value.

SOLUTION:

If you want to insert more rows into the table, you can use the Integer data type instead of smallint. The upper limit of the Integer data type is 2,147,483,647. The cost is 4 bytes.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

Your email address will not be published. Required fields are marked *