SQL Server 2K:
Exec sp_serveroption 'Nipsan','Data Access','True'Select * INTO #tmpWho
From OpenQuery(Nipsan,'Exec sp_who')Select * From #tmpWhoDrop table #tmpWho--Test OK. Nipsan 2002/06/29
Exec sp_serveroption 'Nipsan','Data Access','True'Select * INTO #tmpWho
From OpenQuery(Nipsan,'Exec sp_who')Select * From #tmpWhoDrop table #tmpWho--Test OK. Nipsan 2002/06/29
卻遇到了麻煩,也就是所openquery 的Query不能用變量代替
比如:
Exec sp_serveroption 'sunh','Data Access','True'
declare @str varchar(100)
set @str='Exec peinfo..petest '
print @str
Select * INTO #tmpWho
From OpenQuery(sunh,@str)
Select * From #tmpWho
Drop table #tmpWho
系統將提示
Line 8: Incorrect syntax near '@str'.
請幫忙
而且如何將serverName 也作為變量或者自動取得