SQL 并联更新

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