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.
Published Apr 25, 2022
Version 1.0BobDorr
Microsoft
Joined January 13, 2022
SQL Server Blog
Follow this blog board to get notified when there's new activity