关键字'WHEN'附近的语法不正确 [英] Incorrect syntax near the keyword 'WHEN'

问题描述

尝试使用SQL MERGE无济于事。看起来很简单，好像WHEN只是不正确的语法。救命？ SQL如下：

Trying SQL MERGE to no avail. Seems simple, as if WHEN is simply incorrect syntax. HELP? SQL is as follows:

MERGE INTO myTable AS TARGET USING（SELECT * from myTable，其中actid = 26369和questid = 15）AS SOURCE

当匹配时更新设置状态= 1其中actid = 26369和questid = 15

当没有匹配时插入（xrefid，questid，actid，effdate，status，lastchanged，changedby）


值（16890,0,26369，'2018-07-01'，0，'2019-05-22'，1273）

MERGE INTO myTable AS TARGET USING (SELECT * from myTable where actid = 26369 and questid = 15) AS SOURCE
WHEN MATCHED THEN update set status = 1 where actid = 26369 and questid = 15
WHEN NOT MATCHED THEN insert (xrefid, questid, actid, effdate, status, lastchanged, changedby)
values (16890, 0, 26369, '2018-07-01', 0, '2019-05-22', 1273)

提前感谢您的帮助！

推荐答案

您缺少ON子句。

You are missing the ON clause.

Tom

这篇关于关键字'WHEN'附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！