Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2012-08-29 : 01:45:05
|
| Hi all,when am trying to update a column in a table (million of records/all records) it was processing for a while at one point of time i decided to stop the execution of statement. I found that some records are updated with newly updated records some as same.I want to know how update happend for some records ?(I was thinking that the update will not happen if we stop in middle, correct me if am wrong)and can anyone explain me how update works based on sql server internals Note: its a single update am not used any explicit or implicit transaction. Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-29 : 12:54:32
|
| it wont happen. the update will rollback on cancelling. did you've any triggers attached to target table for update action?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Update