34,590
社区成员
发帖
与我相关
我的任务
分享
--程序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的执行语句相同
--我执行
select * from sysobjects where id = 1522104463
--的结果是下面的数据
Data 1522104463 U 1 0 0 0 0 0 2010-12-28 17:06:48.783 0 0 0 U 1 3 0 2010-12-28 17:06:48.783 0 0 0 0 0 0 0