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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy