UPDATE o SET col2 = c.col3 FROM bo1 AS o JOIN bo2 AS c ON c.col3<>'' WHERE c.col3<>''
UPDATE o SET split = c.datecount FROM Order_Refund_Table AS o JOIN @t2 AS c ON o.orderno=c.orderno
UPDATE o SET col2 = c.col3 FROM bo1 AS o JOIN bo2 AS c ON c.col3<>'' WHERE c.col3<>''
UPDATE o SET split = c.datecount FROM Order_Refund_Table AS o JOIN @t2 AS c ON o.orderno=c.orderno
转载于:https://www.cnblogs.com/ilookbo/p/4952348.html