I tried to update some columns in a destination table from source table. actually the update needs to happen for more than 3 lakhs records. the query has executing for long time, so i cancelled the query manually.
my dought is, is come of the column gets updated into destination table or non of the column gets updated?
A single statement is atomic. Either it will complete or fail. That is unless you have something odd implemented.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
I tried to update some columns in a destination table from source table. actually the update needs to happen for more than 3 lakhs records. the query has executing for long time, so i cancelled the query manually.
my dought is, is come of the column gets updated into destination table or non of the column gets updated?
thanks subetha.
if performance is a concern consider adding an index to speed up update
also do it in batches if log is getting filled up
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
update query issue.
Posted - 08/24/2012 : 09:40:30
