可以写一个简单的存储过程,在你的程序启动后执行(可用Timer控制): CREATE PROCEDURE Remind @ReturnCount int output @StartTime DateTime, @EndTime DateTime, as declare @TempCount int set @TempCount =0 set @ReturnCount =0 begin select @TempCount=count(*) from tb a where a.time(日期)>=@StartTime and a.time<=@EndTime end select @ReturnCount=@ReturnCount+@TempCount print @ReturnCount GO
如果不多的话,你可以增加个 Alarm 表,记录要提示报警日期,定期处理!!!
CREATE PROCEDURE Remind
@ReturnCount int output
@StartTime DateTime,
@EndTime DateTime,
as
declare @TempCount int
set @TempCount =0
set @ReturnCount =0
begin
select @TempCount=count(*) from tb a where a.time(日期)>=@StartTime and
a.time<=@EndTime
end
select @ReturnCount=@ReturnCount+@TempCount
print @ReturnCount
GO