Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns a geography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Syntax
STPointFromWKB ( 'WKB_point' , SRID )
Arguments
WKB_point
Is the WKB representation of the geography Point instance you wish to return. WKB_point is a varbinary(max) expression.SRID
Is an int expression representing the spatial reference ID (SRID) of the geography Point instance you wish to return.
Return Types
SQL Server return type: geography
CLR return type: SqlGeography
OGC type: Point
Remarks
This method throws a FormatException if the input is not well-formatted.
Examples
The following example uses STPointFromWKB() to create a geography instance.
DECLARE @g geography;
SET @g = geography::STPointFromWKB(0x010100000017D9CEF753D347407593180456965EC0, 4326);
SELECT @g.ToString();