我应该在这里合并吗？(Should I do merge here?)

我应该在这里合并吗？(Should I do merge here?)

我有一些不同的项目应该被复制到不同的组织。 我用merge语句完成了这个。 当项目不存在时我工作正常，但下次应该更新它时会在每个组织中创建新项目。

merge items as target using ( select items.name, items.value, items.org from Items ) as source on (target.items.name = source.items.name and target.items.value = '50') when matched then update set target.items.name = source.items.name when not matched by target then Insert(...) Values(...);

我想它有一些东西，条件下次也没有资格，新项目创建，但我不明白为什么..

也许只做简单的插入更好？

I have some some different items that should be copied down to different organizations. I have done this with the merge statement. I works fine one time when items not exists but next time when it should update it creates new items in every organization.

merge items as target using ( select items.name, items.value, items.org from Items ) as source on (target.items.name = source.items.name and target.items.value = '50') when matched then update set target.items.name = source.items.name when not matched by target then Insert(...) Values(...);

I guess it has something todo with that the condition doesn´t qualify next time either and new items creates but I don´t understand why..

Maybe it´s better to just do simple insert?

最满意答案

来自一个组织的项目应更新另一个组织中的项目。

merge语句不支持更新“其他行”。 从概念上讲，它逐行运行。 源和目标已连接（完全外部联接），并且对于每个联接结果，您可以决定发生的一个操作。 对于更新和删除操作发生在连接的目标表行。

您需要使用多个语句。

Items from one organization should update items in another organization.

The merge statement does not support updating "other rows". Conceptually, it operates row-by-row. Source and target are joined (a full outer join) and for each join result you get to decide one action that happens. For update and delete that action happens to the joined target table row.

You need to use multiple statements.