如何批量执行 SQL UPDATE，例如更新顶部? [英] How can I do a SQL UPDATE in batches, like an Update Top?

问题描述

是否可以在 SQL 更新语句中添加 TOP 或某种分页?

Is it possible to add a TOP or some sort of paging to a SQL Update statement?

我有一个 UPDATE 查询，归结为这样的:

I have an UPDATE query, that comes down to something like this:

UPDATE XXX SET XXX.YYY = #TempTable.ZZZ
FROM XXX
INNER JOIN (SELECT SomeFields ... ) #TempTable ON XXX.SomeId=#TempTable.SomeId
WHERE SomeConditions

本次更新会影响数百万条记录，我需要分批进行.当时像 100.000(顺序无关紧要)

This update will affect millions of records, and I need to do it in batches. Like 100.000 at the time (the ordering doesn't matter)

最简单的方法是什么?

推荐答案

是的，我相信您可以在更新语句中使用 TOP，如下所示:

Yes, I believe you can use TOP in an update statement, like so:

UPDATE TOP (10000) XXX SET XXX.YYY = #TempTable.ZZZ
FROM XXX
INNER JOIN (SELECT SomeFields ... ) #TempTable ON XXX.SomeId=#TempTable.SomeId
WHERE SomeConditions

这篇关于如何批量执行 SQL UPDATE，例如更新顶部?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！