USE test;
GO
CREATE PROCEDURE p11111
AS
BEGIN
CREATE TABLE #T2(NAME NVARCHAR(100))
INSERT INTO #T2(name) EXEC sp_msforeachdb "Select '?'"
SELECT *
FROM #t2;
END;
/*
--执行存储过程
exec p11111
*/
结果如图: