//用户登录时提示短信验证后,在目标账套执行以下代码:
INSERT INTO T_SEC_USERPASSPORTACTIVATE(FPASSPORTID,FACTIVATEDATE)
SELECT t1.FPASSPORTID,GETDATE()
FROM T_SEC_USERPASSPORT t1
LEFT JOIN T_SEC_USERPASSPORTACTIVATE t2 ON t1.FPASSPORTID = t2.FPASSPORTID
WHERE t2.FPASSPORTID IS NULL