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