UPDATE zh_Sys_Position SET intOrder=tb.RowIndex FROM zh_Sys_Position ta JOIN ##temp2 tb ON(ta.dictNO=TB.dictNO)
sql更新语句联合查询
