Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the minimum database compatibility level that recognizes the geometry data type instance.
Syntax
.MinDbCompatibilityLevel ( )
Return Types
SQL Server return type: int
CLR return type: int
Remarks
Use MinDbCompatibilityLevel() to test a spatial object for compatibility before changing the compatibility level on a database.
Examples
A. Testing CircularString type for compatibility with compatibility level 110
The following example tests a CircularString instance for compatibility with an earlier version of SQL Server:
DECLARE @g geometry = 'CIRCULARSTRING(3 4, 8 9, 5 6)';
IF @g.MinDbCompatibilityLevel() <= 110
BEGIN
SELECT @g.ToString();
END
B. Testing LineString type for compatibility with compatibility level 100
The following example tests a LineString instance for compatibility with SQL Server 2008:
DECLARE @g geometry = 'LINESTRING(3 4, 8 9, 5 6)';
IF @g.MinDbCompatibilityLevel() <= 100
BEGIN
SELECT @g.ToString();
END