sql-server-2008 - 将 float 纬度和经度转换为地理

Question

如何将 float 纬度和经度值转换为地理类型值？我有@lat和@lon变量。

Answer 1

附带案例说明:

CASE
    WHEN ((@Latitude IS NOT NULL) AND (@Longitude IS NOT NULL))
    THEN geography::Point(@Latitude, @Longitude, 4326)
    ELSE NULL           
END

或带有if的变体:

 DECLARE @Location geography = NULL
 IF (@Latitude IS NOT NULL AND @Longitude IS NOT NULL)
    SET @Location = geography::Point(@Latitude, @Longitude, 4326);