AsBinaryZM (geography Data Type)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2012)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.



Return Types

SQL Server return type: varbinary(max)

CLR return type: SqlBytes



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)