Home
> DB Concepts, SQL Server Questions > Stopping a DELETE statement in middle of its execution – MSDN TSQL forum
Stopping a DELETE statement in middle of its execution – MSDN TSQL forum
–> Question:
I accidentally executed the DELETE statement for a table.
However, I stopped it before it completed.
What effect will this have on the table in Database, is my data safe?
–> My Answer:
In SQL Server by default a single SQL statement is bounded within a Transaction.
So, if you cancelled the DELETE statement execution in between it would have cancelled the overall deletion from the table. So either all of your rows are safe or all gone. SQL Server ensures that a transaction should be completed fully or not at all, one of the ACID properties.
Categories: DB Concepts, SQL Server Questions
ACID Transaction, MSDN TSQL forum
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 