[Fsp2WFuH]

When creating spacial geography point in sql server, the longitude comes first (lng, lat). I always thought it would be latitude then longitude.

Interestingly, some points that I've inserted passed the validation, but later I realized the values were swapped when I tried to query nearest neighbor and the points were no where near.

[NicoJuicy]

There is a geography data type

https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography...