Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.34 KB | None | 0 0
  1. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('LINESTRING(1 -2, 2 3)'), 1, VectorMakeX2(5,5)))
  2. nvarchar: LINESTRING(1 -2, 5 5)
  3. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('LINESTRING(1 -2, 2 3)'), 0, VectorMakeX2(5,5)))
  4. nvarchar: LINESTRING(5 5, 2 3)
  5. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'), 0, VectorMakeX2(5,5)))
  6. nvarchar: MULTIPOINT(5 5, 40 30, 20 20, 30 10)
  7. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'), 2, VectorMakeX2(5,5)))
  8. nvarchar: MULTIPOINT(10 40, 40 30, 5 5, 30 10)
  9. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 2, VectorMakeX2(5,5)))
  10. nvarchar: POLYGON((30 10, 40 40, 5 5, 10 20, 30 10))
  11. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 6, VectorMakeX2(5,5)))
  12. nvarchar: <NULL>
  13. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 5, VectorMakeX2(5,5)))
  14. nvarchar: <NULL>
  15. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 4, VectorMakeX2(5,5)))
  16. nvarchar: POLYGON((30 10, 40 40, 20 40, 10 20, 5 5, 30 10))
  17. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'), 2, VectorMakeX2(5,5)))
  18. nvarchar: MULTIPOINT(10 40, 40 30, 5 5, 30 10)
  19. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('MULTIPOINT ((10 40), (40 30), (20 20), (30 10))'), 2, VectorMakeX2(5,5)))
  20. nvarchar: MULTIPOINT(10 40, 40 30, 5 5, 30 10)
  21. > VALUE @a VARCHAR = 'MULTILINESTRING ((10 10, 20 20, 10 40), (40 40, 30 30, 40 20, 30 10))';
  22. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 2, VectorMakeX2(5,5)))
  23. nvarchar: MULTILINESTRING((10 10, 20 20, 5 5),(40 40, 30 30, 40 20, 30 10))
  24. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 3, VectorMakeX2(5,5)))
  25. nvarchar: MULTILINESTRING((10 10, 20 20, 10 40),(5 5, 30 30, 40 20, 30 10))
  26. > VALUE @a VARCHAR = 'MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)), ((15 5, 40 10, 10 20, 5 10, 15 5)))';
  27. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 2, VectorMakeX2(5,5)))
  28. nvarchar: POLYGON((30 20, 45 40, 5 5, 30 20),(15 5, 40 10, 10 20, 5 10, 15 5))
  29. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 3, VectorMakeX2(5,5)))
  30. nvarchar: POLYGON((30 20, 45 40, 10 40, 5 5, 30 20),(15 5, 40 10, 10 20, 5 10, 15 5))
  31. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 4, VectorMakeX2(5,5)))
  32. nvarchar: POLYGON((30 20, 45 40, 10 40, 30 20),(5 5, 40 10, 10 20, 5 10, 15 5, 5 5))
  33. > VALUE @a VARCHAR = 'MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)),((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),(30 20, 20 15, 20 25, 30 20)))'
  34. > ?GeomWkt(GeomUpdateCoord(StringWktGeom(@a), 4, VectorMakeX2(5,5)))
  35. nvarchar: POLYGON((40 40, 20 45, 45 30, 40 40),(5 5, 10 30, 10 10, 30 5, 45 20, 20 35, 5 5),(30 20, 20 15, 20 25, 30 20))
  36. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 4, VectorMakeX2(5,5)))
  37. nvarchar: POLYGON((30 10, 40 40, 20 40, 10 20, 5 5, 30 10))
  38. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 5, VectorMakeX2(5,5)))
  39. nvarchar: <NULL>
  40. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 4, VectorMakeX2(5,5)))
  41. nvarchar: POLYGON((30 10, 40 40, 20 40, 10 20, 5 5, 30 10))
  42. > ?GeomWkt(GeomUpdateCoord(StringWktGeom('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'), 0, VectorMakeX2(5,5)))
  43. nvarchar: POLYGON((5 5, 40 40, 20 40, 10 20, 30 10, 5 5))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement