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