您可以这样做：
-- add 'loopback' linkedserver if exists (select * from master..sysservers where srvname = 'loopback') exec sp_dropserver 'loopback'goexec sp_addlinkedserver @server = N'loopback', @srvproduct = N'', @provider = N'SQLOLEDB', @datasrc = @@servernamegodeclare @myDynamicSQL varchar(max)select @myDynamicSQL = 'exec sp_who'exec(' select * into #t from openquery(loopback, ''' + @myDynamicSQL + '''); select * from #t ')编辑：添加动态sql接受参数以openquery
