Sql ms ssms error : “Arithmetic overflow error converting expression to data type int”?

Your vlanId column is to big for the datatype int (-2147483647 to 2147483647). Use bigInt Link to SQL Server Doc.

Your vlanId column is to big for the datatype int (-2147483647 to 2147483647). Use bigInt. Link to SQL Server Doc.

Bigint worked thank you – dorsalfin Jul 18 at 10:20.

From MSDN - int, bigint, smallint, and tinyint (Transact-SQL): int Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer.

The value you are trying to insert (2348328434) is outside of these. Use bigint instead.

Bigint worked thank you – dorsalfin Jul 18 at 10:19.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions