22,210
社区成员
发帖
与我相关
我的任务
分享
ALTER FUNCTION FUN1(@A INT)
RETURNS INT
AS
BEGIN
RETURN @A
END
GO
ALTER FUNCTION FUN2(@B INT,@A INT)
RETURNS INT
AS
BEGIN
RETURN @B+DBO.FUN1(@A)
END
GO
DECLARE @x INT
SET @x=1
DECLARE @y INT
SET @Y=2
SELECT DBO.FUN2(@x,@y)
create function fn_001(@i int)
returns int
as
begin
return (@i*2)
end
go
create function fn_002(@i int)
returns @t table (num2 int)
as
begin
insert @t
values(dbo.fn_001(8)+@i)
return
end
go
select * from fn_002(4)
---
20
create function fn_001(@i int)
returns table
as
return
select @i*2 as num
go
/*
select * from fn_001(8)
-----------------------
num
-----------
16
(1 行受影响)
*/
create function fn_002(@i int)
returns @t table (num2 int)
as
begin
insert @t
select num+@i from fn_001(8)
return
end
go
select * from fn_002(4)
/*
num2
-----------
20
(1 行受影响)
*/
表值函数可以嵌套