现有3个程序 A,B,C(不是3个线程,是3个单独的程序)
程序A每次到整点都执行13条左右的insert into data语句
程序B每次到整点过5分都执行几十条insert into data语句,然后执行delete语句
程序C每次到整点过10分都执行几十条insert into data语句,然后执行delete语句
--程序A的执行语句
insert into data(STID,SurveyTime,WaterLevel,SumRainfall,HourRainfalll,DayRainfall,Voltage,State) values('SYQSSI00000000000019',convert(datetime,'2011-06-19 14:00:00',121),55.82,0.0,0.0,0,13.60,0);--程序B的执行语句是
insert into data(STID,SurveyTime,WaterLevel,SumRainfall,HourRainfalll,DayRainfall,Voltage,State) values('SYQSSI00000000000019',convert(datetime,'2011-06-19 14:00:00',121),55.82,0.0,0.0,0,13.60,0);
delete a from data a where ID not in (select max(ID) from data where SurveyTime=a.SurveyTime group by stid);--程序C与B的执行语句相同