IsNull (geography Data Type)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
A property that specifies if the geography instance is null. Returns 'TRUE' if the instance is null; returns 0 if the instance is not null.
Syntax
.IsNull
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Return Types
SQL Server type: bit
CLR type: SqlBoolean
Remarks
IsNull
can be used to test whether a geography instance is null. This can produce somewhat confusing results, returning 0 if the instance is not null, but null if the instance is null.
This method is primarily used by the SQL Server infrastructure; it is recommended that you use the T-SQL predicate IS NULL to test whether a geography instance is null. For more information on the T-SQL predicate IS NULL, see IS NULL (Transact-SQL).
Examples
See Also
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