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)) 

 

posted @ 2015-02-04 17:16  以沫浅夏  阅读(1938)  评论(0编辑  收藏  举报