Sql Server 内嵌表值函数的语法及示例

Sql Server 内嵌表值函数的语法及示例

 

create function[属主名]函数名
([{@parameter_name[as]标量参数数据类型[=default]}[,...n]])
 returns table
 [with <function_option>[,...n]]
 [as]
 return [()select语句]

 

示例

 

--------------------------创建一个内嵌表值函数----------------------------
use teachingmanagesys
go
create function Teachercourse
(@number char(25))
returns table
as
return
(
select Tname
from teacherInfo
where Tno=@number
union select Cno
from Teach
where Tno=@number
)
go
--------------使用创建的函数
use teachingmanagesys
go
select * from teachercourse('020104')