HQY

WHERE (USERID = 949)

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

FROM CHECKINOUT

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://kinber.cn/post/1751.html 转载需授权！

分享到：

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