October 1, 2001 at 2:00 pm
i was running a bad update query in QA and canceled the job midway by hitting (X) in upper right corner. The query was changing EVERY record. I cannot tell if only a few records were changed. I did a controlled test on a test table and no changes were made.
Could any of the first updates gotten thru to the original table.
A soon to be more carefull user.
October 1, 2001 at 2:34 pm
If you execute a simple update (update table1 set col01 = <something>), if you stop execution before its finish, the modifications will not be applied. SQL Server will ROLLBACK all modifications made in the transaction by returning the data to the state it was in at the start of the transaction.
You can read something in BOOKS Online, section "Controlling Transactions".
October 1, 2001 at 10:15 pm
This is corect. All the changes in SQL are considered a single transaction if this is one statement. This would be an implicit transaction.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply