Be careful, this one caused me problems the other day. The WKT (Well-Known Text) format does not match with the geography static function parameter positioning. Reference: Point (geography Data Type) - SQL Server | Microsoft Docs
select geography::Point(10 /*Lat*/, 91 /*Long*/, 4626).ToString()
POINT (91 10)
Note that the static function accepts Lat, Long and the WKT format is reversed, accepting Long, Lat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.