Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-02 : 10:44:16
|
| Steve writes "I cannot figure this error out do you have any ideas what is wrong?Microsoft OLE DB Provider for ODBC Drivers error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '99280000946' overflowed an int column. Maximum integer value exceeded. /CrimeAnalyst/CaseEntryUpdateUI.asp, line 30" |
|
|
TonyH
Starting Member
29 Posts |
Posted - 2002-05-02 : 11:38:45
|
| Hi,I think the max value an int can hold is just over 2 billion.You seem to be trying to convert a varchar to int with a value of 99 billion.TonyHwww.SQLCoder.com - Free Code generation for SQL Server 7/2000 |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-05-02 : 15:37:53
|
| In SQL 2000, there is a new data type called BigInt which will hold values that large. However, I believe there are some situations where BigInt is not supported, so you'll want to read up on the topic in BOL first. |
|
|
|
|
|
|
Overflow error