DROP FUNCTION TabFun
GO
CREATE FUNCTION TabFun
(@mini REAL=0) RETURNS @HeightT TABLE
(surename VARCHAR(22),
Height REAL
)
AS
BEGIN
INSERT INTO @HeightT
SELECT Sure_Name, Height FROM Persons
WHERE Height>@mini
RETURN
END
GO
SELECT * FROM dbo.TabFun(DEFAULT)