MS SQL

MS SQL RSS

inserting decimal values failing

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jul 2008

Posts: 25

Reputation: stockton is an unknown quantity at this point

Solved Threads: 0

stockton

Offline

Light Poster

inserting decimal values failing

Sep 12th, 2008

I have setup the following table:-

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
      WHERE TABLE_NAME = 'TlHold')
   DROP TABLE THold
GO
CREATE TABLE THold (
pid int NOT NULL IDENTITY(1,1),
TS NUMERIC(2,2) NOT NULL,
TR NUMERIC(2,2) NOT NULL,
TB NUMERIC(2,2) NOT NULL,
TP NUMERIC(2,2) NOT NULL,
TP2 NUMERIC(2,2) NOT NULL,
filler1 NUMERIC(2,2) NOT NULL,
filler2 NUMERIC(2,2) NOT NULL,
filler3 NUMERIC(2,2) NOT NULL,
PRIMARY KEY (pid)
);
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
      WHERE TABLE_NAME = 'TlHold')
   DROP TABLE THold
GO
CREATE TABLE THold (
pid int NOT NULL IDENTITY(1,1),
TS NUMERIC(2,2) NOT NULL,
TR NUMERIC(2,2) NOT NULL,
TB NUMERIC(2,2) NOT NULL,
TP NUMERIC(2,2) NOT NULL,
TP2 NUMERIC(2,2) NOT NULL,
filler1 NUMERIC(2,2) NOT NULL,
filler2 NUMERIC(2,2) NOT NULL,
filler3 NUMERIC(2,2) NOT NULL,
PRIMARY KEY (pid)
);

and now I am trying to execute the following insert statement in Enterprise Manager

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
INSERT INTO THold  VALUES (5.40, 2.40, 1.00, 1.15, 2.40, 0,0,0);
INSERT INTO THold  VALUES (5.40, 2.40, 1.00, 1.15, 2.40, 0,0,0);

and it fails with
Server: Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.

I do not understand the necessity of converting numeric to numeric.
Please tell me what I have done wrong.

Last edited by stockton; Sep 12th, 2008 at 11:58 am. Reason: misspelling

Regards,
Alf Stockton www.stockton.co.za

•

Join Date: Aug 2008

Posts: 1,160

Reputation: dickersonka will become famous soon enough

Solved Threads: 137

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: inserting decimal values failing

Sep 12th, 2008

your total digits on each column is 2

also use columns when inserting

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
INSERT INTO theoritcalHold (TS, TR, ...etc) VALUES(.....)
insert into theoritcalHold (TS, TR, ...etc) values(.....)