Temporary table support in 3.6 EA

MikeyC

I'm sure I just don't know how it is supposed to work, or how to use it, but I don't see temporary table support working.

Here is an example:

SELECT DISTINCT
tdl_id,
post_date
INTO #test
FROM edic_cga_details;

SELECT * FROM #test tds;

If I put the cursor next to the * and hit TAB to expand the fields nothing happens. If I add a where clause it helps auto complete the alias (tds) but when I hit the "." it doesn't show any suggestions. (Not even a pop-up.)

Is it that 3.6 EA, just doesn't support temporary table creation with the "INTO #<table>" command?

Bart Read

Sorry, I should make it clear that this only works for CREATE TABLE not SELECT INTO. I was fairly sternly warned not to support SELECT INTO because it's "evil" due to locking issues in msdb (?)... that and the fact that we didn't have time. Apologies.
Bart

MikeyC

Besides it causing a SP to be recompiled every time it is run, do you know why it is considered "evil"?

Consider this a feature request to add SELECT INTO support sometime in the future.

Bart Read

Well, "evil" it may be, but I've just added support for it. You should find it working as you'd like in the final 3.6 release.

Thanks,
Bart

MikeyC

Cool, thanks!

And could you share what ever you have that allows you to create time?

(It must have been easier than you originally thought if it took less than a half hour to add.)

Bart Read

Well, that and it's a bit cheeky to go adding features at this stage... but all the building blocks I needed were already there, it was just a case of sticking them together properly. Our testers are going to kill me though.