Point (geometry Data Type)

**APPLIES TO:** SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

Constructs a geometry instance representing a Point instance from its X and Y values and an SRID.

Syntax

  
Point ( X, Y, SRID )  

Arguments

X
Is a float expression representing the X-coordinate of the Point being generated.

Y
Is a float expression representing the Y-coordinate of the Point being generated.

SRID
Is an int expression representing the spatial reference ID (SRID) of the geometry instance you wish to return.

Return Types

SQL Server return type: geometry

CLR return type: SqlGeometry

Remarks

Examples

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

DECLARE @g geometry;   
SET @g = geometry::Point(1, 10, 0);  
SELECT @g.ToString();  

See Also

Extended Static Geometry Methods