sql server 2008 临时表,该如何处理

sql server 2008 临时表
select username into ##temptb from (select username from huifubiao where huifuid=1) select username from ##temptb

虽然我上面写的不正确，但相信大家看到后都知道我的意思，所以请告诉我，正确写法

[解决办法]
select username into ##temptb 
from (select username from huifubiao where huifuid=1) t

select username from ##temptb
 
像这个没必要临时表了
[解决办法]

SQL code

--加个别名就可以了select username into ##temptb from (select username from huifubiao where huifuid=1)t select username from ##temptb