Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SqlGeography.IsValidDetailed Method

SQL Server 2012

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(Int32) 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.