insert into julicef(id,GPSLng,GPSLat)select id,GPSLng,GPSLat from julice where id=(select min(id)from julice)
insert into juliceg(id,GPSLng,GPSLat,store_id,Lng,Lat,distance)SELECT *, ( 6378.140* acos( cos( radians(GPSLat) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(GPSLng) ) + sin( radians(GPSLat) ) * sin( radians( lat ) ) ) ) AS distance FROM julicef,juli order by id,GPSLng,GPSLat,store_id,Lng,Lat asc
insert into juliceI(id,GPSLng,GPSLat,store_id,Lng,Lat,distance)select top 3 * from juliceg order by id,GPSLng,GPSLat,distance,store_id,Lng,Lat asc
delete from julicef
delete from julice where id=(select min(id)from julice)
delete from juliceg
能写给我吗?
追答CREATE OR REPLACE PROCEDURE PKG_10000 AS试了,不行,请看图
追答你这是sql server ,,,我那个是Oracle,俩个数据库