Export (0) Print
Expand All

AsBinaryZM (geometry DataType)

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.

Applies to: SQL Server (SQL Server 2012 through current version), Azure SQL Database.


SQL Server return type: varbinary(max)

CLR return type: SqlBytes

DECLARE @g1 GEOMETRY = 'Point(1 1 2 3)';

SELECT @g1.STAsBinary();
-- Returns: 0x0101000000000000000000F03F000000000000F03F

SELECT @g1.AsBinaryZM();
--Returns: 0x01B90B0000000000000000F03F000000000000F03F00000000000000400000000000000840

Community Additions

© 2014 Microsoft