表值函数，标量函数

--创建表值函数
CREATE function [dbo].[FNGetRentalOverDue](@id varchar(10))
returns @aa table(contract_id int,rental_id int,ACCRUED_OD_AMT money)
as
begin
exec GetRentalOverDue @id
insert into @aa
select * from dbo.Tb_RentalOverDue
return 
end

 

--根据某一标识列聚合其他列数据

Create Function [dbo].[KFReturn](@Class Varchar(50))
Returns Varchar(8000)
as
Begin
Declare @str Varchar(8000)
Set @str = ''
Select @str = @str + cast(Number as Varchar(50))  + ',' from ClassNo Where Class = @Class
Set @str = SubString(@str,1,len(@str)-1)
Return(@str)
End