How do I fix this incorrect syntax in my Code

Question

When I run my code, I keep getting an error

Incorrect syntax near the keyword 'CONVERT'

I've checked & rechecked and I can't get where the error is

INSERT INTO stock (ID, GOODSNAME, QUANTITY, PRICE, [DESCRIPTION], GOODSIMAGE, REGDATE) 
    SELECT 
        'STOCK-5', 'Pine by 150 Wipes', 120,600.00, 'To Clean Faeces', 
        BulkColumn 
    FROM 
        Openrowset (Bulk 'ImageDirectory\IMG_20180206_113030.jpg', Single_Blob) AS tb_picture, 
        CONVERT(date, '2011/11/11')

also, `CONVERT` had nuances, since your date is confusing enough, please check this [QA](https://stackoverflow.com/a/10304533/4648586). confusing enough: computer might unable distinguish the month and day apart. — Bagus Tesa, Jan 20 '19 at 12:15
you have six columns in the insertion list but seven comma sepearted values in th select list. — Barbaros Özhan, Jan 20 '19 at 12:24

score 1 · Answer 1 · edited Jan 20 '19 at 21:16

1

That expression belongs in the SELECT clause not the FROM clause:

INSERT INTO stock (ID, GOODSNAME, QUANTITY, PRICE, [DESCRIPTION], GOODSIMAGE, REGDATE) 
    SELECT 'STOCK-5', 'Pine by 150 Wipes', 120,600.00,
           'To Clean Faeces', BulkColumn, CONVERT(date,'2011/11/11')
    FROM Openrowset(Bulk 'ImageDirectory\IMG_20180206_113030.jpg', Single_Blob) tb_picture

edited Jan 20 '19 at 21:16

Mr. Royal

21
8

answered Jan 20 '19 at 12:54

Gordon Linoff

1,242,037
58
646
786

score 0 · Answer 2 · answered Jan 20 '19 at 12:55

Here is your current query slightly better formatted

INSERT INTO stock (ID, GOODSNAME, QUANTITY, PRICE, [DESCRIPTION], GOODSIMAGE) 
SELECT 'STOCK-5','Pine by 150 Wipes', 120,600.00,'To Clean Faeces', BulkColumn
FROM Openrowset (Bulk 'ImageDirectory\IMG_20180206_113030.jpg', Single_Blob) as tb_picture
, CONVERT(date,'2011/11/11')

The "as tb_picture" in this query is a table alias, not a selection list alias. The FROM clause has passed, you cannot simply add another expression after that. It should probably go between "BulkColumn" and "FROM"

score 0 · Answer 3 · edited Jan 20 '19 at 14:25

0

Try below query:

INSERT INTO stock (
  ID, GOODSNAME, QUANTITY, PRICE, [DESCRIPTION], 
  GOODSIMAGE, REGDATE
) 
SELECT 
  'STOCK-5', 
  'Pine by 150 Wipes', 
  120, 
  600.00, 
  'To Clean Faeces', 
  BulkColumn, 
  Convert(date, '2011/11/11') 
FROM 
  Openrowset (
    Bulk 'ImageDirectory\IMG_20180206_113030.jpg', 
    Single_Blob
  ) as tb_picture

edited Jan 20 '19 at 14:25

Prashant Pimpale

10,349
9
44
84

answered Jan 20 '19 at 14:04

Mr. Royal

21
8

How do I fix this incorrect syntax in my Code

3 Answers3