guyren(at)icloud(dot)com schrieb am 02.12.2020 um 21:27:
> The Halloween problem is that it is a challenge for the database if
> you’re updating a field that is also in the WHERE clause of the same
> query.
>
> I just saw a presentation from someone about how in SQL Server he
> recommended writing changes to a temp table and then writing them to
> the table as being much more efficient.
It sounds strange to me, that this _is_ actually a problem.
Why exactly is that a problem in SQL Server?
And what are the consequences if you do it nevertheless.