CODEWITHSUNDEEP
sqlsql-server
Mr. Royal
Mr. Royal

Reputation: 25

How do I fix this incorrect syntax in my Code

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

Upvotes: 0

Views: 104

Answers (3)

Gordon Linoff
Gordon Linoff

Reputation: 1269443

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

Upvotes: 1

Mr. Royal
Mr. Royal

Reputation: 25

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

Upvotes: 0

Gert-Jan
Gert-Jan

Reputation: 347

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"

Upvotes: 0

Related Questions