January 30, 2009 at 11:10 am
I'm getting this error whilst trying to update this table using SQL Server Management Studio.
table [dbo].[product]
productID_PK numeric(1,0)
product nvarchar(200)
product_shortname nvarchar(50)
version nvarchar(10)
release_date datetime
in_use bit
uses_reportpack bit
comments nvarchar(MAX)
release_type_FK1 numeric(1,0)
All tables are set to ALLOW NULLs except for productID_PK.
Data already in table:
0, ,NULL,NULL,NULL,1,NULL,NULL,0
other data...
I've checked a couple of times and the data I'm trying to update seems actually valid. Has anyone encountered similar issues?
January 30, 2009 at 11:11 am
The error in the title is cutoff. Could you please post the entire error message?
February 2, 2009 at 1:36 am
Error message reads:
The data in row 11 was not committed.
Error source: .NET SqlClient Data Provider.
Error message: Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated.
February 2, 2009 at 1:59 am
Jon,
May be you are trying to store data out of range because size for productID_PK is Numeric(1,0).
Try This example:
--------------------------------
Declare @N Numeric(1,0)
SET @N = 10
Select @N as Number
You will get below error:
Msg 8115, Level 16, State 8, Line 2
Arithmetic overflow error converting int to data type numeric.
If you set a value less then 10, It will not throw any error message...
February 2, 2009 at 5:12 am
Cheers
February 2, 2009 at 7:13 am
Jon (2/2/2009)
Cheers
Does this mean your problem has been solved?
December 22, 2010 at 10:23 am
Reason and solution for this error is..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply