1、创建表房间入住信息use hotelmanagementsysgocreate table 房间入住信息(g荏鱿胫协name varchar(50),gno varchar(50),rno varchar(50),rtype varchar(50))
2、内联式函数的创建use hotelmanagementsysgoselect *from 房间入住信息where gno = 'G101'
3、多语句式表值函数的创建use hotelmanagementsysgocreate function getallconsumelistby爿讥旌护gno(@gno varchar(50))returns tableasreturn(select *from 房间入住信息where gno = @gno
4、多语句式表值函数的引用use hotelmanagementsysgoselect * from getallconsumelistbygno('G101')
