常è§é—®é¢˜ä¸Žåˆ†æž?/div>
å…³é—
内部数æ®é”™è¯¯
排查æ–ÒŽ(gu¨©)³•åQ?/span>
在å¸å¥—库˜q行下列è¯å¥åQŒå¦‚æžœä¸èƒ½æ‰¾åˆ°è®°å½•ï¼Œåˆ™è¯´æ˜Žå½“å‰ç™»å½•éƒ½çš„部门或公å¸æ²¡æœ‰åQŒå…¶ä¸?ey00313='1001',1001为登录ååQŒæ›¿æ¢è¿™ä¸ªå³å¯ã€?/p>
SELECT userId=pj00401, userName=pj00402, userState=pj00412, pj00421, pj00301, pj00302, pj02501, pj02506, ey00307=ey00307 + ey00311,
thisTime=Convert(varchar(19), GetDate(), 21), ey00312 FROM sdpj004
INNER JOIN sdey003 ON pj00421=ey00301
INNER JOIN sdpj003 ON pj00301=pj00417
INNER JOIN sdpj025 ON pj00311=pj02501
WHERE ey00313='1001'