同表更新

update a
set
a.StepCode=b.StepCode,
a.StepName=b.StepName,
a.allowtime=b.allowtime,
a.ActionTypeID=b.ActionTypeID,
a.YesStep=b.YesStep,
a.NoStep=b.NoStep,
a.Note=b.Note,
a.StepID=b.StepID,
a.OtherFlowID=b.OtherFlowID,
a.ActionID=b.ActionID,
a.SortID=b.SortID,
a.BEdit=b.BEdit,
a.BAny=b.BAny,
a.BRead=b.BRead,
a.Layer=b.Layer,
a.bpreStep=b.bpreStep,
a.StepNum=b.StepNum,
a.FlowID=b.FlowID,
a.bAssgnPreSingleSel=b.bAssgnPreSingleSel,
a.opentime=b.opentime
from WmDocStep a join WmDocStep b
on a.DocID = 164058
and b.DocID = 164620 and a.StepID=b.StepID

转载于:https://www.cnblogs.com/Freeking/p/5103205.html