Convert Geometry data into a Geography data in MS SQL Server

DECLARE @geogGEOGRAPHY;DECLARE @geomGEOMETRY;SET @geom =Geometry::stgeomfromtext ('POLYGON (-99.213546752929688 19.448402404785156,-99.2157974243164 19.449802398681641,-99.2127456665039 19.450002670288086, -99.213546752929688 19.448402404785156))',4326); SET @geom = @geom. Makevalid ()--Force to valid geometrySET @geom = @geom. Stunion (@geom. Ststartpoint ());--forces the correct the Geometry ring orientationSET @geog =Geography::stgeomfromtext (@geom. Stastext (),4326) SELECT @geog. Starea ();

　

Reference: http://blogs.msdn.com/b/edkatibah/archive/2008/08/19/ Working-with-invalid-data-and-the-sql-server-2008-geography-data-type-part-1b.aspx

Convert Geometry data into a Geography data in MS SQL Server