刪除刷卡資料....

**Admin** 11/22/2012, 13:30

例:刪除2010/09/10~2010/09/22刷卡資料
delete from onlinemsg
where recorddatetime > '2010/09/10 00:00:00' and recorddatetime < '2010/09/23 00:00:00'
delete from onlinemsg_temp
where recorddatetime > '2010/09/10 00:00:00' and recorddatetime < '2010/09/23 00:00:00'
update onlinemsg_main set recorddatetime = null , empno = null , cardno = null
where recorddatetime > '2010/09/10 00:00:00' and recorddatetime < '2010/09/23 00:00:00'
--不得砍任何記錄 countNo 流水號