Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gayathris
Starting Member
11 Posts |
 Posted - 2012-06-04 : 06:45:53
|
| Could you please tell me the sql query for the following case. I have a polygon which has id,name,latitude and longitude.I used the query: select ASTEXT(polygon) AS polygon from table_name; This gives me all details but are congested. How can I seperate them? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-06-04 : 13:01:16
|
| The result is just a string so there are lots of ways to "parse" it. Can you describe what you want to do with the result? Or how you want to separate the result? |
 |
|
|
gayathris
Starting Member
11 Posts |
Posted - 2012-06-13 : 03:40:38
|
| Hello LampreyCould you tell me how to parse it? In the end, I want to find whether a point is inside or outside the polygon. |
|
|
|
|
|
|
Polygon query