Toad World® Forums

Code complete for temp tables


#1

I type the following code to put data into a temp table. Then code complete
works for selecting the temp table, which is great.

Now I will add an alias to the temp table of “tt” and replace the
“*” with “tt.” so I can select fields from the temp
table.

select tt.

from #TempTable1 as tt

but I cannot get the fields to display from #TempTable1 after I type the dot or
if I force the list of fields.

I know this is possible as I use a third party add on that I use in SSMS that
does this nicely.

This is the one last things that is preventing me from moving from SSMS
completely as I can code much faster in SSMS with this add-on than I can in
Toad. So what I end up doing is typing the code in SSMS and then copying and
pasting into Toad.

Let me know if you need any further information.

Thanks,

Matt

image004.png


#2

+1 from me. I sometimes miss this feature too…

Cheers
Ercan

On Wed, Apr 28, 2010 at 4:48 PM, Matt Sprygada
wrote:

I type the following code to put data into a temp table. Then code complete
works for selecting the temp table, which is great.

 

 

 

Now I will add an alias to the temp table of “tt” and replace the
“*” with “tt.” so I can select fields from the temp table.

 

select tt.

from  #TempTable1 as tt

 

but I cannot get the fields to display from #TempTable1 after I type the dot
or if I force the list of fields.

 

I know this is possible as I use a third party add on that I use in SSMS
that does this nicely.

 

This is the one last things that is preventing me from moving from SSMS
completely as I can code much faster in SSMS with this add-on than I can in
Toad. So what I end up doing is typing the code in SSMS and then copying and
pasting into Toad.

 

Let me know if you need any further information.

 

Thanks,

Matt


#3

We don’t support listing columns of temp tables unfortunately.

/Mauritz

Quest Software