Advertisement
Guest User

Calculo por SQL

a guest
Oct 8th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.35 KB | None | 0 0
  1. DECLARE @v_polygon_string VARCHAR(1000)
  2. DECLARE @g Geography
  3. SET @v_polygon_string = 'POLYGON((
  4. -70.106903276165 -20.253605204701,
  5. -70.107765556612 -20.253818617830,
  6. -70.107654186777 -20.254495614967,
  7. -70.106938131964 -20.254400336391,
  8. -70.106903276165 -20.253605204701
  9. )) '
  10. SET @g = Geography::STGeomFromText(@v_polygon_string, 4977)
  11. SELECT @g.STArea()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement