sql server 2008之自定义函数-表值函数

1、创建表房间入住信息

use hotelmanagementsys

go

create table 房间入住信息(

gname varchar(50),

gno varchar(50),

rno varchar(50),

rtype varchar(50)

)

2、内联式函数的创建

use hotelmanagementsys

go 

select *

from 房间入住信息 

where gno = 'G101'

3、多语句式表值函数的创建

use hotelmanagementsys

go

create function getallconsumelistbygno(@gno varchar(50))

returns table

as

return(

select *

from 房间入住信息

where gno = @gno

4、多语句式表值函数的引用

use hotelmanagementsys

go

select * from getallconsumelistbygno('G101')