sqlserver临时表

exec('select * into #aaa from Base_Email' )

select * from #aaa

drop table #aaa


(48 行受影响)
消息 208，级别 16，状态 0，第 4 行
对象名 '#aaa' 无效。


组装字符串不能写入临时表吗 ? 为什么同样写法有的机器又能执行.

---

SQL code:

exec ('select * into #temp from student;select * from #temp;')


这样写

---

exec('select * into #aaa from Base_Email select * from #aaa drop table #aaa ' )

---

引用

SQL codeexec ('select * into #temp from student;select * from #temp;')
这样写

但是我想在外面使用临时表.还有很多后续操作

---

--sql 2000自带库pubs的表authors的测试情况.
SQL code:
exec('select * into #aaa from authors select * from #aaa drop table #aaa ' )

/*
au_id au_lname au_fname phone address city state zip contract
----------- ---------------------------------------- -------------------- ------------ ---------------------------------------- -------------------- ----- ----- --------
172-32-1176 White