作者:海边遗忘的时光_958 | 来源:互联网 | 2018-04-20 07:26
SQLServer2K:Execsp_serveroptionNipsan,DataAccess,TrueSelect*INTO#tmpWhoFromOpenQuery(Nipsan,Execsp_who)Select*From#tmpWhoDroptable#tmpWho--TestOK.Nipsan2002
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