如何在代码中修复此错误语法

Question

当我运行我的代码时，我总是收到一个错误。

关键字“转换”附近的不正确语法

我已经检查过了，但是我找不到错误在哪里

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

Answer 1

该表达式属于SELECT子句，而不是FROM子句：

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

Answer 2

下面是您当前的查询格式稍好一些

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

此查询中的"as tb_picture“是表别名，而不是选择列表别名。FROM子句已经传递，您不能简单地在该子句之后添加另一个表达式。它应该介于"BulkColumn“和"FROM”之间。

Answer 3

请尝试以下查询：

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