sql 批量更新

UPDATE dbo.PP_MOperation
SET MOperationName_ENG=QQQQ.MOperationENName
FROM PP_MOperation,QQQQ
WHERE PP_MOperation.MOperationName=QQQQ.MOperationName

原文地址:https://www.cnblogs.com/dekevin/p/2547255.html