Difference between Geometry & Polygon functions- SQL Server
up vote
0
down vote
favorite
Studying for the 70-461 and my book (Joes2pro Vol3) makes no mention of a difference between STGeomFromText & STPolyFromText functions, though it reads like there is a discernible difference between the two.
Examples asked to run are here
Select Geometry::STGeomFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Select Geometry::STPolyFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Which gives me exactly the same output and Microsoft docs is a little light on the subject for both these functions. All I can screen out is one is a geometry instance and the other is a geometryPolygon instance ?
Can anyone tell me when one is used over the other and what the above actually means ?
Kind regards,
SQLBoffin.
sql
sql-server edited Nov 22 at 19:56
jarlh
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
add a comment |
up vote
0
down vote
favorite
Studying for the 70-461 and my book (Joes2pro Vol3) makes no mention of a difference between STGeomFromText & STPolyFromText functions, though it reads like there is a discernible difference between the two.
Examples asked to run are here
Select Geometry::STGeomFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Select Geometry::STPolyFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Which gives me exactly the same output and Microsoft docs is a little light on the subject for both these functions. All I can screen out is one is a geometry instance and the other is a geometryPolygon instance ?
Can anyone tell me when one is used over the other and what the above actually means ?
Kind regards,
SQLBoffin.
sql
sql-server edited Nov 22 at 19:56
jarlh
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Studying for the 70-461 and my book (Joes2pro Vol3) makes no mention of a difference between STGeomFromText & STPolyFromText functions, though it reads like there is a discernible difference between the two.
Examples asked to run are here
Select Geometry::STGeomFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Select Geometry::STPolyFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Which gives me exactly the same output and Microsoft docs is a little light on the subject for both these functions. All I can screen out is one is a geometry instance and the other is a geometryPolygon instance ?
Can anyone tell me when one is used over the other and what the above actually means ?
Kind regards,
SQLBoffin.
sql
sql-server edited Nov 22 at 19:56
jarlh
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
Studying for the 70-461 and my book (Joes2pro Vol3) makes no mention of a difference between STGeomFromText & STPolyFromText functions, though it reads like there is a discernible difference between the two.
Examples asked to run are here
Select Geometry::STGeomFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Select Geometry::STPolyFromText('Polygon ((0 0, 28 0, 28 21, 0 21, 0 0))',0)
Which gives me exactly the same output and Microsoft docs is a little light on the subject for both these functions. All I can screen out is one is a geometry instance and the other is a geometryPolygon instance ?
Can anyone tell me when one is used over the other and what the above actually means ?
Kind regards,
SQLBoffin.
sql
sql-server sql
sql-server edited Nov 22 at 19:56
jarlh
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
edited Nov 22 at 19:56
jarlh
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
edited Nov 22 at 19:56
jarlh
28.2k52137
edited Nov 22 at 19:56
jarlh
28.2k52137
edited Nov 22 at 19:56
jarlh
28.2k52137
28.2k52137
asked Nov 22 at 16:14
SQLBoffin
12
asked Nov 22 at 16:14
SQLBoffin
12
asked Nov 22 at 16:14
SQLBoffin
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
STGeomFromText() will take the WKT for any type of geometry (polygons of course but also points and lines) whereas STPolyFromText() will only do polygons.
answered Nov 22 at 22:40
Ben Thul
22.1k32445
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
STGeomFromText() will take the WKT for any type of geometry (polygons of course but also points and lines) whereas STPolyFromText() will only do polygons.
answered Nov 22 at 22:40
Ben Thul
22.1k32445
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
add a comment |
up vote
0
down vote
STGeomFromText() will take the WKT for any type of geometry (polygons of course but also points and lines) whereas STPolyFromText() will only do polygons.
answered Nov 22 at 22:40
Ben Thul
22.1k32445
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
add a comment |
up vote
0
down vote
up vote
0
down vote
STGeomFromText() will take the WKT for any type of geometry (polygons of course but also points and lines) whereas STPolyFromText() will only do polygons.
answered Nov 22 at 22:40
Ben Thul
22.1k32445
STGeomFromText() will take the WKT for any type of geometry (polygons of course but also points and lines) whereas STPolyFromText() will only do polygons.
answered Nov 22 at 22:40
Ben Thul
22.1k32445
answered Nov 22 at 22:40
Ben Thul
22.1k32445
answered Nov 22 at 22:40
Ben Thul
22.1k32445
answered Nov 22 at 22:40
Ben Thul
22.1k32445
22.1k32445
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
add a comment |
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
Great thanks for your response. So really the STGeomFromText() function is basically just the combination of the STPointFromText(), STLineFromText() and STPolyFromText(). For some reason I was expecting the answer to be more complicated but ill take it. Cheers
– SQLBoffin
Nov 23 at 12:56
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434827%2fdifference-between-geometry-polygon-functions-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
