Export (0) Print
Expand All

SqlGeography.IsValidDetailed Method ()

 

Applies To: SQL Server 2016 Preview

Returns a message to help identify validity issues with a spatial object.

Namespace:   Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(IsDeterministic = true, IsPrecise = false)]
public string IsValidDetailed()

Return Value

Type: System.String

A message indicating whether the spatial object is valid or not valid, and if not valid, why not.

If data is not valid for multiple reasons, only one will be returned. Each message will have a unique ID, so the process of detecting validity and fixing it can be automated. An object can be automatically validated by calling the MakeValid method.

Indexing values for sub-objects will start counting each curve from 1. The invalid curve could be accessed with the STCurveN method with the given value. The same is true for STRingN, passed index for rings matched value used for STRingN to get the same ring.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft