SQL: What on earth is Halloween protection?

added by DotNetKicks
2/4/2019 12:28:35 PM

1 Kicks, 412 Views

If you've worked with SQL Server (or with databases in general) for any length of time, you will have heard someone refer to "Halloween protection". It refers to a problem where update operations could inadvertently end up modifying a row more than once. I saw someone who was pretty knowledgeable complaining about just this problem ...