当前位置: 代码迷 >> Sql Server >> 急等 sql函数修改有关问题
  详细解决方案

急等 sql函数修改有关问题

热度:108   发布时间:2016-04-27 14:15:05.0
急等 sql函数修改问题
SQL code
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo ALTER FUNCTION [dbo].[fnGetDistance] --LatBegin 开始经度 --LngBegin 开始维度(@LatBegin REAL, @LngBegin REAL, @LatEnd REAL, @LngEnd REAL)        RETURNS FLOAT       ASBEGIN       --距离(千米)       DECLARE @Distance      REAL       DECLARE @EARTH_RADIUS  REAL       SET @EARTH_RADIUS = 6378.137                     DECLARE @RadLatBegin  REAL,               @RadLatEnd    REAL,               @RadLatDiff   REAL,               @RadLngDiff   REAL              SET @RadLatBegin = @LatBegin *PI()/ 180.0        SET @RadLatEnd = @LatEnd *PI()/ 180.0        SET @RadLatDiff = @RadLatBegin - @RadLatEnd        SET @RadLngDiff = @LngBegin *PI()/ 180.0 - @LngEnd *PI()/ 180.0               SET @Distance = 2 *ASIN(               SQRT(                   POWER(SIN(@RadLatDiff / 2), 2)+COS(@RadLatBegin)*COS(@RadLatEnd)                    *POWER(SIN(@RadLngDiff / 2), 2)               )           )              SET @Distance = @Distance * @EARTH_RADIUS        --SET @Distance = Round(@Distance * 10000) / 10000               RETURN @DistanceEND

要怎么修改才能Select dbo.fnGetDistance
('119.959416','30.273575',(select hotel_mapx from hotelinfo),(select hotel_mapx from hotelinfo))

------解决方案--------------------
declare @a type
select @a=(select top 1 hotel_mapx from hotelinfo)

Select dbo.fnGetDistance('119.959416','30.273575',@a,@a)

  相关解决方案