How do I generate 3d WKT FROM A Sql Server geometry or geography types

[المشرف العام]

If I have the point POINT (-75.45454 25.12345 1024 ) in a geometry or geography column in SQL Server, but render it with STAsText() I lose the Z dimension.

SELECT geography::STGeomFromText('POINT (-75.45454 25.12345 1024 )', 4326).STAsText() AS point

POINT (-75.45454 25.12345)

​

How do I get the full WKT? There is nothing listed in OGC Methods on Geography Instances.



أكثر...