Difference between Geometry & Polygon functions- SQL Server
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 '18 at 19:56
jarlh
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
add a comment |
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 '18 at 19:56
jarlh
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
add a comment |
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 '18 at 19:56
jarlh
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
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 '18 at 19:56
jarlh
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
edited Nov 22 '18 at 19:56
jarlh
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
edited Nov 22 '18 at 19:56
jarlh
28.6k52138
edited Nov 22 '18 at 19:56
jarlh
28.6k52138
edited Nov 22 '18 at 19:56
jarlh
28.6k52138
28.6k52138
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
asked Nov 22 '18 at 16:14
SQLBoffinSQLBoffin
12
12
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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 '18 at 22:40
Ben ThulBen Thul
22.3k32747
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 '18 at 12:56
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 '18 at 22:40
Ben ThulBen Thul
22.3k32747
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 '18 at 12:56
add a comment |
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 '18 at 22:40
Ben ThulBen Thul
22.3k32747
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 '18 at 12:56
add a comment |
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 '18 at 22:40
Ben ThulBen Thul
22.3k32747
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 '18 at 22:40
Ben ThulBen Thul
22.3k32747
answered Nov 22 '18 at 22:40
Ben ThulBen Thul
22.3k32747
answered Nov 22 '18 at 22:40
Ben ThulBen Thul
22.3k32747
answered Nov 22 '18 at 22:40
Ben ThulBen Thul
22.3k32747
22.3k32747
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 '18 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 '18 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 '18 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 '18 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.
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
