The statement has been terminated

This applies to T-SQL.

This statement means nothing is performed, the SQL query is not committed; the query has been rollback.

This can happen to an UPDATE query when there is a large data-set to update and something happened (network disconnected or user stopped it halfway).

For instance, if you try to UPDATE one million records, and before it can finish, you pressed to the stop button. If it says

"The statement has been terminated. Query was canceled by user."

Then no single record is updated.

It is not easy to simulate this using INSERT. For instance, if you try to INSERT a million record, and before it can finished, you pressed the stop button. It will say

"Query was canceled by user."

And even though not one million records has been inserted, but some will already been inserted.

This suggests that UPDATE query involves stricter commit transaction check than INSERT query, which is proper.

And that INSERT query will commit transaction one by one while UPDATE query commit transaction in a batch.