UPDATE DBMX_INTERFACE1 SET [STATE]=2,ERROR_FLAG=1,ERROR_REASON='ERROR,管理碼有誤!管理碼可能不存在'
FROM (
SELECT DATA_ID ID
FROM DBMX_INTERFACE1
WHERE [STATE]<>1
AND not exists(select * from CP where CP_DM= GLM)
) ERR
WHERE ERR.ID=DATA_ID
FROM (
SELECT DATA_ID ID
FROM DBMX_INTERFACE1
WHERE [STATE]<>1
AND not exists(select * from CP where CP_DM= GLM)
) ERR
WHERE ERR.ID=DATA_ID