Advertisement
Guest User

Untitled

a guest
Sep 27th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. SELECT geometry::STGeomFromText('POINT (635641.32 5815631.39 100)', 28355) geom
  2. SELECT CONVERT(varchar(max), geometry::STGeomFromText('POINT (635641.32 5815631.39 100)', 28355).AsBinaryZM(), 2) zmhex
  3. SELECT CONVERT(varchar(max), geometry::STGeomFromText('POINT (635641.32 5815631.39 100)', 28355).STAsBinary(), 2) nozmhex
  4.  
  5. geom
  6. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  7. 0xC36E0000010D3D0AD7A3F26523418FC2F5D8532F56410000000000005940
  8.  
  9. zmhex
  10. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  11. 01E90300003D0AD7A3F26523418FC2F5D8532F56410000000000005940
  12.  
  13. nozmhex
  14. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  15. 01010000003D0AD7A3F26523418FC2F5D8532F5641
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement