Arithmetic overflow - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Arithmetic overflow

Author

Topic

raz2009
Starting Member

2 Posts

Posted - 2009-11-05 : 05:34:08

Hi everybody! I am having a very strange on my SQL Server 2000. I have a field of type 'bigint' in a table, when I create a new row with a value like '100000000003' every thing works ok but if want to update an existing row by setting the value of this field to '100000000003' I a having the following error :

[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow converting expression to data type int

.
Any idea???

This is a part of the structure of my table:

CREATE TABLE [dbo].[T_AMENDEMENT_DI] (
	[LG_ID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[LG_DECLARATION_ID] [bigint] NULL ,
        ...

'LG_DECLARATION_ID' is the field that is causing trouble.
Thanks in advance!

The best is still to come!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-05 : 05:45:47

Please show your update statement.

No, you're never too old to Yak'n'Roll if you're too young to die.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-11-05 : 07:16:20

You'll be getting an implicit conversion that you aren't expecting.

Post the query.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

raz2009
Starting Member

2 Posts

Posted - 2009-11-05 : 08:49:00

Thanks for replying! I'm just trying to do it from scrath in the SQL Server Entreprise manager (SQLS 2000)by typing the value in the cell, and I'm having the error.

The best is still to come!

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2009-11-05 : 10:24:25

If this is just typing direct via SQL-EM I suspect you've a real problem.

try the same change using a SQL script.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources