HasZ (geography Data Type)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns 1 (true) if a spatial object contains at least one Z value; otherwise, it returns 0 (false).
Syntax
.HasZ
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: bit
CLR return type: Boolean
Remarks
Examples
DECLARE @p GEOGRAPHY = 'Point(1 1 1 1)'
SELECT @p.HasZ
--Returns: 1 (true)
See Also
Extended Methods on Geography Instances
Z (geography Data Type)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om