Click here to Skip to main content
15,880,037 members
Home / Discussions / Database
   

Database

 
GeneralRe: image in database Pin
Eddy Vluggen2-Apr-15 9:50
professionalEddy Vluggen2-Apr-15 9:50 
QuestionSSRS Report is exporting in 4 different tabs rather in one tab, I want it to be exported to one excel tab Pin
indian14331-Mar-15 9:08
indian14331-Mar-15 9:08 
QuestionRe-Error Pin
Member 1116162531-Mar-15 2:26
Member 1116162531-Mar-15 2:26 
AnswerRe: Re-Error Pin
CHill6031-Mar-15 2:42
mveCHill6031-Mar-15 2:42 
GeneralRe: Re-Error Pin
Member 1116162531-Mar-15 2:59
Member 1116162531-Mar-15 2:59 
GeneralRe: Re-Error Pin
Simon_Whale31-Mar-15 3:08
Simon_Whale31-Mar-15 3:08 
QuestionRetrive column names from temp table Pin
SHAH MAULIK31-Mar-15 2:14
SHAH MAULIK31-Mar-15 2:14 
AnswerRe: Retrive column names from temp table Pin
CHill6031-Mar-15 2:40
mveCHill6031-Mar-15 2:40 
From this article[^]
Quote:
Another oddity of the local temporary table (and the local temporary stored procedure) is that it has a different name in the metadata to the one you give it in your routine or batch. If the same routine is executed simultaneously by several processes, the Database Engine needs to be able to distinguish between the identically-named local temporary tables created by the different processes. It does this by adding a numeric string to each local temporary table name left-padded by underscore characters. Although you specify the short name such as #MyTempTable, what is actually stored in TempDB is made up of the table name specified in the CREATE TABLE statement and the suffix. Because of this suffix, local temporary table names must be 116 characters or less.
If you remove the where from your code you will see that the table name is actually
#tmp_table__________________________________________________________________________________________________________000000000002
So you do need to use a like clause but not the one you have commented out. Like this
where t.name LIKE '#tmp_table%'

SuggestionRe: Retrive column names from temp table Pin
Richard Deeming31-Mar-15 8:59
mveRichard Deeming31-Mar-15 8:59 
GeneralRe: Retrive column names from temp table Pin
CHill6031-Mar-15 11:28
mveCHill6031-Mar-15 11:28 
SuggestionRe: Retrive column names from temp table Pin
Smart00331-Mar-15 19:13
professionalSmart00331-Mar-15 19:13 
GeneralRe: Retrive column names from temp table Pin
CHill6031-Mar-15 20:39
mveCHill6031-Mar-15 20:39 
AnswerRe: Retrive column names from temp table Pin
Richard Deeming31-Mar-15 9:00
mveRichard Deeming31-Mar-15 9:00 
GeneralRe: Retrive column names from temp table Pin
Mycroft Holmes31-Mar-15 12:51
professionalMycroft Holmes31-Mar-15 12:51 
GeneralRe: Retrive column names from temp table Pin
SHAH MAULIK31-Mar-15 23:26
SHAH MAULIK31-Mar-15 23:26 
QuestionError Pin
Member 1116162531-Mar-15 2:11
Member 1116162531-Mar-15 2:11 
AnswerRe: Error Pin
CHill6031-Mar-15 2:19
mveCHill6031-Mar-15 2:19 
QuestionRe: Error Pin
Richard Deeming31-Mar-15 8:54
mveRichard Deeming31-Mar-15 8:54 
AnswerRe: Error Pin
CHill6031-Mar-15 12:36
mveCHill6031-Mar-15 12:36 
AnswerRe: Error Pin
Mycroft Holmes31-Mar-15 12:48
professionalMycroft Holmes31-Mar-15 12:48 
GeneralRe: Error Pin
Richard Deeming1-Apr-15 0:39
mveRichard Deeming1-Apr-15 0:39 
QuestionConvert msaccess pivot to mssql pivot Pin
kdaras30-Mar-15 22:22
kdaras30-Mar-15 22:22 
AnswerRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 2:44
mveCHill6031-Mar-15 2:44 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
kdaras31-Mar-15 19:45
kdaras31-Mar-15 19:45 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 20:43
mveCHill6031-Mar-15 20:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.