--更新资产包状态UPDATE T1 SETT1ZDate=T0ZDateT1ZCBDZT=T0ZCBDZTFROM U_PABS T0INNER JOIN U_PABS T1 ON T1DocEntry=T0BaseEntry AND T1DocType=DRBWHERE T0DocEntry=DocEntry AND T0DocType=ZB -- SELECT 1帮我转换为pgsql

日期: 2026-09-24
标签: 教育

--更新资产包状态 UPDATE U_PABS T1 SET ZDate=T0.ZDate, ZCBDZT=T0.ZCBDZT FROM U_PABS T0 WHERE T1.DocEntry=T0.BaseEntry AND T1.DocType='DRB' AND T0.DocEntry=@DocEntry AND T0.DocType='ZB'

--SELECT 1

--更新资产包状态UPDATE T1 SETT1ZDate=T0ZDateT1ZCBDZT=T0ZCBDZTFROM U_PABS T0INNER JOIN U_PABS T1 ON T1DocEntry=T0BaseEntry AND T1DocType=DRBWHERE T0DocEntry=DocEntry AND T0DocType=ZB -- SELECT 1帮我转换为pgsql

原文地址: https://www.cveoy.top/t/topic/feHt 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录

上一篇: 故宫的特点帮我用200字详细描述
下一篇: σ 键特点：将成键轨道沿着键轴旋转任意角度图形及符号均保持不变即键轨道对键轴呈圆柱型对称或键轴是n重轴。可记为头碰头。