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')