declare @TrackerNumber varchar(15)
declare @Date datetime declare @Latitude float declare @Longitude float declare @Speed float declare @Direction int DECLARE temp2 CURSOR FOR OPEN temp2; --得到一行数据,并将其复制给本地变 FETCH FROM temp2 INTO @TrackerNumber, @Date,@Latitude,@Longitude,@Speed,@Direction; insert into GpsTrackerData(Gps_Imei,Gps_Datatime,Gps_Latitude,Gps_Longitude,Gps_Speed,Gps_Direction) values(@TrackerNumber, @Date,@Latitude,@Longitude,@Speed,@Direction); --SQLSTATE 00000: 操作执行成功并且未产生任何类型的警告或异常情况。 --通过这个可以检查是否到达最后一行 while @@FETCH_STATUS=0 begin FETCH FROM temp2 INTO @TrackerNumber, @Date,@Latitude,@Longitude,@Speed,@Direction; insert into GpsTrackerData(Gps_Imei,Gps_Datatime,Gps_Latitude,Gps_Longitude,Gps_Speed,Gps_Direction) values(@TrackerNumber, @Date,@Latitude,@Longitude,@Speed,@Direction); end close temp2 |
|