远程访问Function时报错Remote table-valued function calls are not allowed.

开始是这样调用的:
select * from [LinkedServer].[db name].dbo.[function name](param1, param2)

原因:

Only table-valued functions can be used in the FROM clause.

解决办法:

If it's a scalar function, use this:

SELECT  * FROM    OPENQUERY(LinkedServer, 'SELECT [db name].dbo.[function name](param1, param2)')
 
posted @ 2017-05-17 11:16  (john_zhang)  阅读(615)  评论(0编辑  收藏  举报