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