Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden More RBAR and "Tuning" UPDATEs RE: More RBAR and "Tuning" UPDATEs
Zarko Jovanovic
Right there with Babe
Points: 732
More actions
March 14, 2008 at 12:52 am
#789473
what about this:
update table1
set table1.column1 = #table.column1, table1.column2 = #table.column2
from table1, #table
where table1.pk=#table.pk