select用存储过程返回的表

12/1/2004来源:SQL技巧人气:27008

SQL Server 2K:


Exec sp_serveroption 'Nipsan','Data access','True'

Select *  INTO #tmpWho
From OpenQuery(Nipsan,'Exec sp_who')

Select * From #tmpWho

Drop table #tmpWho

--Test OK. Nipsan 2002/06/29