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

總結

以上是生活随笔為你收集整理的SQL 并联更新的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。