Sql Server 内嵌表值函数的语法及示例
1
create
function
[
属主名
]
函数名
2 ( [ {@parameter_name[as ] 标量参数数据类型 [ =default ] } [ ,...n ] ])
3 returns table
4 [ with <function_option>[,...n ] ]
5 [ as ]
6 return [ ()select语句 ]
2 ( [ {@parameter_name[as ] 标量参数数据类型 [ =default ] } [ ,...n ] ])
3 returns table
4 [ with <function_option>[,...n ] ]
5 [ as ]
6 return [ ()select语句 ]
示例
1
--
------------------------创建一个内嵌表值函数----------------------------
2 use teachingmanagesys
3 go
4 create function Teachercourse
5 ( @number char ( 25 ))
6 returns table
7 as
8 return
9 (
10 select Tname
11 from teacherInfo
12 where Tno = @number
13 union select Cno
14 from Teach
15 where Tno = @number
16 )
17 go
18 -- ------------使用创建的函数
19 use teachingmanagesys
20 go
21 select * from teachercourse( ' 020104 ' )
2 use teachingmanagesys
3 go
4 create function Teachercourse
5 ( @number char ( 25 ))
6 returns table
7 as
8 return
9 (
10 select Tname
11 from teacherInfo
12 where Tno = @number
13 union select Cno
14 from Teach
15 where Tno = @number
16 )
17 go
18 -- ------------使用创建的函数
19 use teachingmanagesys
20 go
21 select * from teachercourse( ' 020104 ' )