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 !!!

score 11 · Answer 1 · edited May 23 '17 at 11:53

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 '17 at 11:53

Community

1
1

answered Aug 01 '13 at 06:25

hkf

4,440
1
30
44

Complete list of SQL Server [data types](http://msdn.microsoft.com/en-us/library/ms187752.aspx) – Damien_The_Unbeliever Aug 01 '13 at 06:28
But how would i map it in java ? What does represent the [MONEY] in java ? – Wassan Aug 01 '13 at 08:33

score 3 · Answer 2 · answered Aug 01 '13 at 06:49

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 ,
)

score 1 · Answer 3 · answered Aug 01 '13 at 06:26

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)
)

But how would i represent the these data type in JAVA ? – Wassan Aug 01 '13 at 08:37 — Wassan, Aug 01 '13 at 08:37

Expecting ID Error - SQL Server

3 Answers3