insert into appreg(id,appname,createtime,activetime,memo,state,overduetime) values(200001,'报表',getdate(),getdate(),'',1,5)在做一个报表,给报表加监听器执行这两个sql,有数据的话就修改,没有的话就添加update appreg set activetime =getdate() where id =200001
每五分钟执行一次
http://blog.csdn.net/jlds123/article/details/6387571