HQY 一个和谐有爱的空间

SELECT     TOP (20000) USERID, CHECKTIME, CHECKTYPE, VERIFYCODE, SENSORID, Memoinfo, WorkCode, sn, UserExtFmt

FROM         CHECKINOUT

WHERE     (USERID = 949)

INSERT      TOP (2000)

INTO            CHECKINOUT(USERID, CHECKTIME, CHECKTYPE, VERIFYCODE, SENSORID, Memoinfo, WorkCode, sn, UserExtFmt)

VALUES     (949, CONVERT(DATETIME, '2021-0x-0x 1x:0x:00', 102), 'I', 1, '1', NULL, '0', 'CBP92001601xx', 1)

SELECT     TOP (20000) USERID, CHECKTIME, CHECKTYPE, VERIFYCODE, SENSORID, Memoinfo, WorkCode, sn, UserExtFmt

FROM         CHECKINOUT

WHERE     (USERID = 949) AND (CHECKTIME >= CONVERT(DATETIME, '2021-07-01 00:00:00', 102))

推荐本站淘宝优惠价购买喜欢的宝贝:

本文链接：https://hqyman.cn/post/1751.html 非本站原创文章欢迎转载，原创文章需保留本站地址！

休息一下~~