STNumCurves (geography Data Type)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns the number of curves in a one-dimensional geography instance.
Syntax
.STNumCurves()
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Return Types
SQL Server return type: geography
CLR return type: SqlGeography
Remarks
One-dimensional spatial data types include LineString, CircularString, and CompoundCurve. An empty one-dimensional geography instance returns 0.
STNumCurves
() works only on simple types; it does not work with geography collections like MultiLineString. NULL is returned when the geography instance is not a one-dimensional data type.
Null is returned for uninitialized geography instances.
Examples
A. Using STNumCurves() on a CircularString instance
The following example shows how to get the number of curves in a CircularString
instance:
DECLARE @g geography;
SET @g = geography::Parse('CIRCULARSTRING(-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653)');
SELECT @g.STNumCurves();
B. Using STNumCurves() on a CompoundCurve instance
The following example uses STNumCurves()
to return the number of curves in a CompoundCurve
instance.
DECLARE @g geography;
SET @g = geography::Parse('COMPOUNDCURVE(CIRCULARSTRING(-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))');
SELECT @g.STNumCurves();
See Also
Spatial Data Types Overview
OGC Methods on Geography Instances
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru