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

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