All geek questions in one place

SQL Server Managment Studio and commit

Suppose I had a table with many records, I wanted to update the entire record in this table using SQL Server 2008 management studio, I typed:

Refresh table set col1 = val

It will take some time for this command to update all records, now if I pressed stop excutioin, what exactly will happen, some records will be updated and fixed or will not be the same as I never tried this command?

+3
source share
1 answer

everything will be or nothing, this operation based on a set of SQL Server uses an implicit transaction, if the explicit has not been started, this is a way to provide ACID

, , , , ! F5

+4

Source: https://habr.com/ru/post/1703490/

More articles:


All Articles