执行这个SQL脚本时,我遇到了以下错误:
MERGE TridionCentres TridionCentres
USING (SELECT * FROM #CentresToUpdate) NewInfo
ON (TridionCentres.[publication id] = NewInfo.[publication id] AND
TridionCentres.centre_number = NewInfo.centre_number)
WHERE matched THEN
UPDATE
SET TridionCentres.centre = NewInfo.centre,
TridionCentres.[date] = NewInfo.[date];
错误:
消息 156,级别 15,状态 1,第 5 行
关键字“WHERE”附近有语法错误。
我看不出哪里出了问题!