Point (geography Data Type)

Constructs a geography instance representing a Point instance from its latitude and longitude values and a spatial reference ID (SRID).

Składnia

Point ( Lat, Long, SRID )

Arguments

• Lat
  Is a float expression representing the x-coordinate of the Point being generated.

• Long
  Is a float expression representing the y-coordinate of the Point being generated. For more information on valid latitude and longitude values, see Point.

• SRID
  Is an int expression representing the SRID of the geography instance you wish to return.

Return Types

SQL Server return type: geography

CLR return type: SqlGeography

Examples

The following example uses Point() to create a geography instance.

DECLARE @g geography; 
SET @g = geography::Point(47.65100, -122.34900, 4326)
SELECT @g.ToString();

Zobacz także

Inne zasoby

Extended Static Geography Methods