james (2/9/2009)

---

So it adds a temp table into memory or on the permamnent media or both? How long does the temp table last?

There have been times when I want to use a temp table to hold some data for the length of a webpage, but I generally have a table called tempSomethingMeaningful and clear the table when I am done. This way I don't have to worry about setting up the columns every time.

Sankar Reddy (2/10/2009)

---

This is written as a trivia question and to raise awareness that certain questionable features will not be supported in future versions of SQL Server. Follow the link to learn about functionalities that might be going away in near future.

Features Not Supported in a Future Version of SQL Server

I do NOT recommend using this method and once again it is written to raise awareness.

declare @ int, @@ int create table 
# (_ int, _@ int, _@@ int) insert 
# values(1,1 - + + - -
- - + - 1, 1 - + -  + - + 
- - + -  + - 1) select @=_,@@=_@ from 
# select * into
## from
# drop table 
# drop table 
##