sql geography类型(地理坐标) 赋值

sql 语句赋值

  update [lishui].[dbo].[t_NearbyService] set  [location]= geography::Point(0,0, 4326)
      ,[locationbaidu]=geography::Point(0,0, 4326) where [location] is null

f_geolatlng.STDistance(geography::Point(@lat,@lng, 4326)) 
原文地址:https://www.cnblogs.com/liyangLife/p/4272850.html