PLM中图纸历史版本号改成和当前版本号一致

DECLARE @FCODE nvarchar(50) = ‘1000110787’; — ← 只改这里：换成你的文档编码

— 第1步：预览主表“当前版本号”（即全部历史版本将被统一成的值）
SELECT FVERNO, FMAXVERNO, FMAXVER, FMINVERNO, FMINVER
FROM T_PLM_PDM_BASE WHERE FCODE = @FCODE;

— 第2步：把该文档所有历史版本统一成主表当前版本号
UPDATE v
SET v.FVERNO = b.FVERNO,
v.FMAXVERNO = b.FMAXVERNO,
v.FMAXVER = b.FMAXVER,
v.FMINVERNO = b.FMINVERNO,
v.FMINVER = b.FMINVER
FROM T_PLM_PDM_BASEVERSION v
JOIN T_PLM_PDM_BASE b ON b.FCODE = v.FCODE
WHERE v.FCODE = @FCODE;

— 第3步：核对结果
SELECT v.FID, v.FCREATEDATE, v.FVERNO, v.FMAXVERNO, v.FMAXVER, v.FMINVERNO, v.FMINVER
FROM T_PLM_PDM_BASEVERSION v
WHERE v.FCODE = @FCODE
ORDER BY v.FCREATEDATE DESC;

DECLARE @FCODE nvarchar(50) = '1000110787';  -- ← 只改这里：换成你的文档编码

-- 第1步：预览主表“当前版本号”（即全部历史版本将被统一成的值）
SELECT FVERNO, FMAXVERNO, FMAXVER, FMINVERNO, FMINVER
FROM T_PLM_PDM_BASE WHERE FCODE = @FCODE;

-- 第2步：把该文档所有历史版本统一成主表当前版本号
UPDATE v
SET  v.FVERNO    = b.FVERNO,
     v.FMAXVERNO = b.FMAXVERNO,
     v.FMAXVER   = b.FMAXVER,
     v.FMINVERNO = b.FMINVERNO,
     v.FMINVER   = b.FMINVER
FROM T_PLM_PDM_BASEVERSION v
JOIN T_PLM_PDM_BASE b ON b.FCODE = v.FCODE
WHERE v.FCODE = @FCODE;

-- 第3步：核对结果
SELECT v.FID, v.FCREATEDATE, v.FVERNO, v.FMAXVERNO, v.FMAXVER, v.FMINVERNO, v.FMINVER
FROM T_PLM_PDM_BASEVERSION v
WHERE v.FCODE = @FCODE
ORDER BY v.FCREATEDATE DESC;