摘要: CREATE TABLE #Temp([Name] NVARCHAR(200),[Count] NVARCHAR(200))INSERT INTO #TempEXEC LinkedServer.[DBName].[dbo].[SP_Name] @para1,@para2 阅读全文
posted @ 2017-05-17 15:07 (john_zhang) 阅读(807) 评论(0) 推荐(0) 编辑
摘要: Only table-valued functions can be used in the FROM clause. 解决办法: If it's a scalar function, use this: SELECT * FROM OPENQUERY(LinkedServer, 'SELECT [ 阅读全文
posted @ 2017-05-17 11:16 (john_zhang) 阅读(615) 评论(0) 推荐(0) 编辑