SQL SERVER 链接服务器（不允许使用远程表值函数调用）解决

if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#tmp') and type='U')
DROP TABLE #tmp

DECLARE @i INT,
        @sql varchar(8000)

/*创建临时表*/        
Create Table #tmp
(col1  INT)

SET @i = 1

/*组合SQL*/
SET @sql = 'SELECT * FROM WorkFlow.dbo.ft_test('+CAST(@i AS varchar)+')'
SET @sql = ''''+@sql+''''
SELECT  @sql = 'SELECT * FROM OPENQUERY(jkMssql, '+@sql+')'

/*插入临时表*/
INSERT INTO #tmp EXEC (@sql)
 
SELECT * FROM #tmp