復制代碼 代碼如下:

CREATE FUNCTION dbo.Foo()
RETURNS int
AS
BEGIN
declare @n int
select @n=3
return @n
END

復制代碼 代碼如下:

CREATE FUNCTION dbo.Foo()
RETURNS TABLE
AS
return select id, title from msgs

復制代碼 代碼如下:

CREATE FUNCTION fn_FindReports (@InEmpId nchar(5))
RETURNS @retFindReports TABLE (empid nchar(5) primary key,
empname nvarchar(50) NOT NULL,
mgrid nchar(5),
title nvarchar(30))
...