Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Developer Reference for SQL Server 2012
Developer Reference
Developer's Guide (Database Engine)
Microsoft.SqlServer.Types
SqlGeometry Class
SqlGeometry Methods
AsBinaryZM Method
AsGml Method
AsTextZM Method
BufferWithCurves Method
BufferWithTolerance Method
CurveToLineWithTolerance Method
Deserialize Method
Filter Method
GeomFromGml Method
InstanceOf Method
ISqlSpatialGridIndexable.BufferForDistanceQuery Method
ISqlSpatialGridIndexable.GetBoundingBoxCorners Method
ISqlSpatialGridIndexable.GetGridCoverage Method
ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Method
IsValidDetailed Method
MakeValid Method
MinDbCompatibilityLevel Method
Parse Method
Point Method
Populate Method
Read Method
Reduce Method
Serialize Method
ShortestLineTo Method
STArea Method
STAsBinary Method
STAsText Method
STBoundary Method
STBuffer Method
STCentroid Method
STContains Method
STConvexHull Method
STCrosses Method
STCurveN Method
STCurveToLine Method
STDifference Method
STDimension Method
STDisjoint Method
STDistance Method
STEndPoint Method
STEnvelope Method
STEquals Method
STExteriorRing Method
STGeomCollFromText Method
STGeomCollFromWKB Method
STGeometryN Method
STGeometryType Method
STGeomFromText Method
STGeomFromWKB Method
STInteriorRingN Method
STIntersection Method
STIntersects Method
STIsClosed Method
STIsEmpty Method
STIsRing Method
STIsSimple Method
STIsValid Method
STLength Method
STLineFromText Method
STLineFromWKB Method
STMLineFromText Method
STMLineFromWKB Method
STMPointFromText Method
STMPointFromWKB Method
STMPolyFromText Method
STMPolyFromWKB Method
STNumCurves Method
STNumGeometries Method
STNumInteriorRing Method
STNumPoints Method
STOverlaps Method
STPointFromText Method
STPointFromWKB Method
STPointN Method
STPointOnSurface Method
STPolyFromText Method
STPolyFromWKB Method
STRelate Method
STStartPoint Method
STSymDifference Method
STTouches Method
STUnion Method
STWithin Method
ToString Method
Write Method
Expand Minimize
This topic has not yet been rated - Rate this topic

SqlGeometry.STCentroid Method

SQL Server 2012

Returns the geometric center of a SqlGeometry instance consisting of one or more polygons.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)
C#
C++
F#
JScript
VB
Copy 
'Declaration
<SqlMethodAttribute(IsDeterministic := True, IsPrecise := False)> _
PublicFunctionSTCentroidAsSqlGeometry
'Usage
DiminstanceAsSqlGeometryDimreturnValueAsSqlGeometryreturnValue = instance.STCentroid()

Return Value

Type: Microsoft.SqlServer.Types.SqlGeometry
A SqlGeometry object that represents the geometric center of the calling SqlGeometry.

STCentroid returns null if the SqlGeometry instance is not a Polygon or MultiPolygon type.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.