首先表为PRDT 和 U001 中 根据SPC 模糊匹配 查出值

SELECT u001.SPC
FROM u001
JOIN PRDT ON u001.SPC = CAST(PRDT.spc AS NVARCHAR(MAX));

然后修改PRDT表中的 QTY_UK2 的值

UPDATE PRDT
SET PRDT.PK2_QTY = u001.PK2_QTY
FROM PRDT
JOIN u001 ON PRDT.SPC LIKE '%' + u001.SPC + '%';

然后修改PRDT 中的 PK2_UT值为箱

UPDATE prdt
SET PK2_UT = '箱'
WHERE CAST(prdt.SPC AS NVARCHAR(MAX)) IN (SELECT u001.SPC FROM u001)