CREATE PROCEDURE Test2
AS
CREATE TABLE #t(x INT PRIMARY KEY)
INSERT INTO #t VALUES (2)
SELECT Test2Col = x FROM #t
GO
CREATE PROCEDURE Test1
AS
CREATE TABLE #t(x INT PRIMARY KEY)
INSERT INTO #t VALUES (1)
SELECT Test1Col = x FROM #t
EXEC Test2
GO
CREATE TABLE #t(x INT PRIMARY KEY)
INSERT INTO #t VALUES (99)
GO
EXEC Test1
GO
to 256m(一塌糊涂) :
看得见的,否则select * into temp1 from #temp 怎么能执行?此时已经存在一个数据库对象#temp,如supsuccess(口气不小) 所说,在临时数据库(tempdb)里。只不过名字不一样罢了:当然啦,数据库要保证名字的唯一性,否则,两个存储过程都创建了临时表,都叫#temp,同时执行,如果在DBMS那里名字也一样,怎么办?