SQL Temporary Table Title different from original
I made a stored procedure which I want to store the results of it in a "temporary table"
I named the table
#SalesDiff
HOWEVER,
the title of table under temporary tables folder is shown as
#SalesDiff___________________________________________________________00000000023F
Below is basic query format
SELECT * INTO #SalesDiff FROM (
SELECT A, B, C
FROM
(.... ) D
sql
sql-server edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
add a comment |
I made a stored procedure which I want to store the results of it in a "temporary table"
I named the table
#SalesDiff
HOWEVER,
the title of table under temporary tables folder is shown as
#SalesDiff___________________________________________________________00000000023F
Below is basic query format
SELECT * INTO #SalesDiff FROM (
SELECT A, B, C
FROM
(.... ) D
sql
sql-server edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
2
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03
add a comment |
I made a stored procedure which I want to store the results of it in a "temporary table"
I named the table
#SalesDiff
HOWEVER,
the title of table under temporary tables folder is shown as
#SalesDiff___________________________________________________________00000000023F
Below is basic query format
SELECT * INTO #SalesDiff FROM (
SELECT A, B, C
FROM
(.... ) D
sql
sql-server edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
I made a stored procedure which I want to store the results of it in a "temporary table"
I named the table
#SalesDiff
HOWEVER,
the title of table under temporary tables folder is shown as
#SalesDiff___________________________________________________________00000000023F
Below is basic query format
SELECT * INTO #SalesDiff FROM (
SELECT A, B, C
FROM
(.... ) D
sql
sql-server sql
sql-server edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
edited Nov 21 '18 at 20:06
Martin Smith
342k58574683
342k58574683
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
asked Nov 21 '18 at 20:01
Daniel OhDaniel Oh
204
204
2
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03
add a comment |
2
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03
2
2
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03
add a comment |
1 Answer
1
active
oldest
votes
Temporary tables only exist for the lifespan of the connection that creates them. When the SQL engine creates your table for you, it appends information to the end to distinguish your version of #SalesDiff from the version generated by the other three users running the same stored procedure.
Within your connection, the engine keeps track of the version information automagically, so you don't need to worry about the extension.
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
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%2f53419690%2fsql-temporary-table-title-different-from-original%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
Temporary tables only exist for the lifespan of the connection that creates them. When the SQL engine creates your table for you, it appends information to the end to distinguish your version of #SalesDiff from the version generated by the other three users running the same stored procedure.
Within your connection, the engine keeps track of the version information automagically, so you don't need to worry about the extension.
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
add a comment |
Temporary tables only exist for the lifespan of the connection that creates them. When the SQL engine creates your table for you, it appends information to the end to distinguish your version of #SalesDiff from the version generated by the other three users running the same stored procedure.
Within your connection, the engine keeps track of the version information automagically, so you don't need to worry about the extension.
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
add a comment |
Temporary tables only exist for the lifespan of the connection that creates them. When the SQL engine creates your table for you, it appends information to the end to distinguish your version of #SalesDiff from the version generated by the other three users running the same stored procedure.
Within your connection, the engine keeps track of the version information automagically, so you don't need to worry about the extension.
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
Temporary tables only exist for the lifespan of the connection that creates them. When the SQL engine creates your table for you, it appends information to the end to distinguish your version of #SalesDiff from the version generated by the other three users running the same stored procedure.
Within your connection, the engine keeps track of the version information automagically, so you don't need to worry about the extension.
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
answered Nov 21 '18 at 20:08
Eric BrandtEric Brandt
2,3421724
2,3421724
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
add a comment |
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
Nice and simple answer, +1
– Pawel Czapski
Nov 21 '18 at 22:29
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%2f53419690%2fsql-temporary-table-title-different-from-original%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
2
yes this is normal. It is done behind the scenes to disambiguate the possibility of tables with the same name in different sessions. do you have a question?
– Martin Smith
Nov 21 '18 at 20:03