AsBinaryZM (geography Data Type)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a geometry instance augmented with any Z (elevation) and M (measure) values carried by the instance.
Syntax
.AsBinaryZM()
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: varbinary(max)
CLR return type: SqlBytes
Remarks
Examples
DECLARE @g1 GEOGRAPHY = 'Point(1 1 2 3)';
SELECT @g1.STAsBinary();
-- Returns: 0x0101000000000000000000F03F000000000000F03F
SELECT @g1.AsBinaryZM();
--Returns: 0x01B90B0000000000000000F03F000000000000F03F00000000000000400000000000000840
See Also
Extended Methods on Geography Instances
M (geography Data Type)
Z (geography Data Type)