create procedure chkuser
@id varchar(20)
asdeclare @t datetime
set @t=getdate()update user_chk set chk=0 where
user_id=@id and datediff(d,starttime,@t)<0 and datediff(d,endtime,@t)>0update user_chk set chk=1 where
user_id=@id and datediff(d,starttime,@t)>0 or datediff(d,endtime,@t)<0go
@id varchar(20)
asdeclare @t datetime
set @t=getdate()update user_chk set chk=0 where
user_id=@id and datediff(d,starttime,@t)<0 and datediff(d,endtime,@t)>0update user_chk set chk=1 where
user_id=@id and datediff(d,starttime,@t)>0 or datediff(d,endtime,@t)<0go
UPDATE tb SET chk=0 WHERE DATEDIFF(dd,GEDATE(),end_time)>0