![sql server 对Geography 的增(insert)和查询(select) sql server 对Geography 的增(insert)和查询(select)](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
insert: Location为 Geography类型 INSERT INTO [oss1].[dbo].[Order] ([Location])
VALUES
(
geography :: STGeomFromText (
'POINT(55.9271035250276 -3.29431266523898)',
4326)
)
查询select:select location.Lat ,location.Long from [Order] //查询 Geography类型的 经(Long)纬(Lat)度:
其他复杂查询 如其他文档:https://www.cnblogs.com/ytwy/p/5977848.html
https://www.liangzl.com/get-article-detail-6302.html
参考文档:https://www.mssqltips.com/sqlservertip/1965/sql-server-geography-data-type/