Expecting ID Error - SQL Server

Question

I have a problem when i create a table in SQL Server

once i chose DOUBLE as the data type, the error jumped on my face !!!

THIS is the following code :

CREATE TABLE BATCH 
( Product_Name  VARCHAR(200) NOT NULL, 
  Product_Brand VARCHAR(100) NOT NULL, 
  CONSTRAINT Price_FK FOREIGN KEY (Product_Name,Product_Brand)REFERENCES Product   (Product_Name,Product_Brand),
  BATCH_Date AS GETDATE(),
  BATCH_OriginalPrice DOUBLE NOT NULL DEFAULT 0,
  BATCH_TAX DOUBLE NOT NULL DEFAULT 0,
  BATCH_ProductCost DOUBLE NOT NULL DEFAULT 0 ,
)

The error is like this after each double Incorrect syntax near the keyword 'NOT'

and when i pass the mouse over it, it says " Incorrect syntax near 'NOT'. Expecting ID "

Can someone tell me what's the problem !!!

Community · Accepted Answer · 2017-05-23 11:53:36Z

11

double isn't a data type in SQL, you'll have to use float or real.

With your example you could use money as well.

related: What represents a double in sql server?

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Aug 1, 2013 at 6:25

hkf

4,5201 gold badge32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Damien_The_Unbeliever Over a year ago

Complete list of SQL Server data types

Wassan Over a year ago

But how would i map it in java ? What does represent the [MONEY] in java ?

Novice · Accepted Answer · 2013-08-01 06:49:42Z

3

You cannot use DOUBLE in SQL SERVER. Try using Decimal or Float or Real or Money or even Smallmoney. See HERE

CREATE TABLE BATCH 
( Product_Name  VARCHAR(200) NOT NULL, 
  Product_Brand VARCHAR(100) NOT NULL, 
  CONSTRAINT Price_FK FOREIGN KEY (Product_Name,Product_Brand)REFERENCES Product (Product_Name,Product_Brand),
  BATCH_Date AS GETDATE(),
  BATCH_OriginalPrice REAL NOT NULL DEFAULT 0,
  BATCH_TAX REAL NOT NULL DEFAULT 0,
  BATCH_ProductCost REAL NOT NULL DEFAULT 0 ,
)

answered Aug 1, 2013 at 6:49

Novice

5582 gold badges9 silver badges21 bronze badges

Comments

Devart · Accepted Answer · 2013-08-01 06:26:31Z

1

Try to use DECIMAL, FLOAT or REAL datatypes -

CREATE TABLE BATCH ( 
    Product_Name VARCHAR(200) NOT NULL, 
    Product_Brand VARCHAR(100) NOT NULL, 
    BATCH_OriginalPrice DECIMAL(18,2) NOT NULL DEFAULT 0, 
    BATCH_TAX DECIMAL(18,2) NOT NULL DEFAULT 0, 
    BATCH_ProductCost DECIMAL(18,2) NOT NULL DEFAULT 0 , 
    BATCH_Date AS GETDATE(), 
    CONSTRAINT Price_FK FOREIGN KEY (Product_Name,Product_Brand)
    REFERENCES Product (Product_Name,Product_Brand)
)

answered Aug 1, 2013 at 6:26

Devart

120k23 gold badges172 silver badges189 bronze badges

1 Comment

Wassan Over a year ago

But how would i represent the these data type in JAVA ?

Collectives™ on Stack Overflow

Expecting ID Error - SQL Server

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related