SQL Server 2008 Books Online (October 2009)
Point (geometry Data Type)

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

Other Resources

Extended Static Geometry Methods

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker