select用存储过程返回的表

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 2004/12/3