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 paramet开发者_C百科ers" error.
Is there a limitation with table-value functions and views?
This works for me:
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
精彩评论