在 SQL Server 的视图中使用表值函数 [英] Using a table-value function inside a view in SQL Server

问题描述

如果我尝试以下查询，我有一个可以正常工作的表值函数:

I have a table-value function that works correctly if I try the following query:

SELECT    *
FROM    dbo.GetScheduleForEmployee() AS schedule

但是，如果我尝试使用该查询创建视图，则会收到参数太少"错误.

However if I try to create a view with that query I get a "too few parameters" error.

表值函数和视图是否有限制?

Is there a limitation with table-value functions and views?

推荐答案

这对我有用:

CREATE FUNCTION dbo.GetScheduleForEmployee()
RETURNS TABLE
AS
        RETURN
        (
        SELECT  1 AS id
        UNION ALL
        SELECT  2
        )
GO

CREATE VIEW myview
AS
SELECT  *
FROM    GetScheduleForEmployee() AS schedule

GO

SELECT  *
FROM    myview

这篇关于在 SQL Server 的视图中使用表值函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！