关于Execute的问题
use pubs
EXECUTE('SELECT ID=IDENTITY(INT,1,1) INTO #QQ FROM jobs')
EXECUTE('SELECT * FROM #QQ')
Messages:
------------
(14 row(s) affected)
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name '#QQ'.
为什么执行第一个Execute可以,而第二个Execute不可以?