CODEWITHSUNDEEP
sqlsql-insert
PIPRON79
PIPRON79

Reputation: 141

SQL INSERT INTO

I have the below query:-

CREATE TABLE #FCO3
(TYPE_CODE varchar (100),
 SKU varchar (100),
 QtyOnHand int);

INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005060','1);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005066','8);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005067','1);

It is throwing out an error of:

Msg 102, Level 15, State 1, Line 109 Incorrect syntax near 'FC03'.

Can anyone help on what is causing this as I must be missing something obvious

Thanks.

Upvotes: 0

Views: 66

Answers (2)

david sam
david sam

Reputation: 531

try this:-

INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005060',1);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005066',8);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005067',1)

Upvotes: 2

Ian Kenney
Ian Kenney

Reputation: 6426

you have unmatched quotes around the quantity

try: 

CREATE TABLE #FCO3
(TYPE_CODE varchar (100),
 SKU varchar (100),
 QtyOnHand int);

INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005060',1);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005066',8);
INSERT INTO #FCO3 (TYPE_CODE, SKU, FREQUENCY) VALUES ('FC03','1005067',1);

Upvotes: 3

Related Questions