sqlserver 如何利用表与表批量更新
UPDATE a SET a.Name = b.Describe --收件地编码 FROM WMS_Material a JOIN ErpMater b ON b.MaterialNo = a.Code
posted on 2021-12-29 12:43 HOT SUMMER 阅读(158) 评论(0) 编辑 收藏 举报
UPDATE a SET a.Name = b.Describe --收件地编码 FROM WMS_Material a JOIN ErpMater b ON b.MaterialNo = a.Code
posted on 2021-12-29 12:43 HOT SUMMER 阅读(158) 评论(0) 编辑 收藏 举报