How to convert FLOAT to INT in SQL Server2000
-
Hi all How to convert FLOAT to INT in SQL Server2000 When i use cast or convert function get this error Server: Msg 232, Level 16, State 3, Line 1 Arithmetic overflow error for type int, value = 2400000000.000000. The statement has been terminated. Thank
-
Hi all How to convert FLOAT to INT in SQL Server2000 When i use cast or convert function get this error Server: Msg 232, Level 16, State 3, Line 1 Arithmetic overflow error for type int, value = 2400000000.000000. The statement has been terminated. Thank
-
Max value for INT data type is 2147483647 Use BIGINT as the value you are trying to convert is more than the max value of INT
Regards KP
It is clear, but if i'm still needed to convert bigest value to more easy, is an way exists???
-
It is clear, but if i'm still needed to convert bigest value to more easy, is an way exists???