Constructs a geography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).
Point ( Lat, Long, SRID )
Is a float expression representing the x-coordinate of the Point being generated.
Is a float expression representing the y-coordinate of the Point being generated.
Is an int expression representing the SRID of the geography instance you wish to return.
SQL Server return type: geography
CLR return type: SqlGeography
The following example uses Point() to create a geography instance.
Point()
geography
DECLARE @g geography; SET @g = geography::Point(-122.34900, 47.65100, 4326) SELECT @g.ToString();
I think the Lat only can be between -90 and 90 degrees (+90 for the north pole and -90 for the south pole?), is that correct?
DECLARE @g geography; SET @g = geography::Point(-122.34900, 47.65100, 4326)SELECT @g.ToString();